Loading lesson path
Concept visual
Start at both ends
Return the hour for a specified time:
Hour(#14:48:23#);
Formula
The Hour() function returns the hour part of a time/datetime.This function returns an integer between 0 and 23.
time )
Formula
Required. A numeric or string expression that can represent a valid time/datetimeReturn the hour for the current time:
Hour(Now());Return the hour for a specified datetime: SELECT Hour(#24/10/2016 11:18:34 PM#);
❮ MS Access Functions