Access: Second Function

In Access, the Second function returns the second of the minute (a number from 0 to 59) given a time value.

The syntax for the Second function is:

Second ( time_value )

time_value is a valid time.

For example:

Second (#10:42:58 PM#) would return 58

Second (#10:14:13 AM#) would return 13

Second (#22/11/2003 10:01:04 PM#) would return 4

VBA Code

The Second function can be used in VBA code. For example:

Dim LSecond As Integer

LSecond = Second (#10:13:58 AM#)

In this example, the variable called LSecond would now contain the value of 58.

You can also use the Second function in a query.