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.