Second(date)

For a date/time value, returns the ordinal for the second, an integer from 0 to 59.

See also DatePart, Hour, and Minute.

date

Any date.

Usage

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.