Access Second Function

Last updated: August 27, 2026.

The Second function returns the seconds component of a time as an integer from 0 through 59.

Syntax

Second(time)

Examples

Second(#3:45:21 PM#)        ' 21
Second(#10:07:43 AM#)       ' 43
OrderSecond: Second([CreatedAt])

If the argument is Null, Second returns Null. Use a Date/Time value instead of locale-dependent text whenever possible.

See the Microsoft VBA function reference.

Moving an Access application to the web? See practical Microsoft Access replacement options.

admin

admin

Leave a Reply

Your email address will not be published.