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 Second function returns a number between 0 and 59, inclusive, representing the second of the minute of the hour.
The syntax for the Second 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 Second function to obtain the second of the minute from a specified time. Now the MySecond variable would contain the value of 27.
You can also use the Second function in a query.
If you'd like to see how it works, enter SQL statement and press Execute
dzone | digg | del.icio.us |