SECOND()

SECOND() returns the seconds portion of a specified DateTime as a number.

Use SECOND() to isolate the seconds portion of a DateTime.

Function Format

SECOND(D)

SECOND() returns a numeric value denoting the seconds portion of a DateTime.

If the DateTime is purely a date, then SECOND() returns a zero value.

Examples

Using a 24-hour clock and a time of 11:12:32 p.m.:

SECOND(‘23:12:32‘) = 32