Access: Second Function

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:

Second ( time )

The required time argument is any numeric or string expression, that can represent a time. If number is Null, this function returns a Null.


Second (#05/05/1985 3:45:21 PM#)      returns 21 
Second (#10:07:43 AM#)                     returns 43

VBA Code

Dim MySecond As Integer 
MySecond = Second(#4:12:27#)

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.

SQL query

You can also use the Second function in a query.

SELECT Second(#10:02:54 PM#) AS Expr1 
FROM Orders


Leave a Reply

Your email address will not be published.