Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.
In Access, the Hour function returns a number between 0 and 23, inclusive, that represents the hour of the day corresponding to the time provided as an argument.
The syntax for the Hour function is:
The required time argument is any numeric or string expression, that can represent a time. If number is Null, this function returns a Null.
This example uses the Hour function to obtain the hour from a specified time. Now the MyHour variable would contain the value of 15.
You can also use the Hour function in a query.
If you'd like to see how it works, enter SQL statement and press Execute
dzone | digg | del.icio.us |