The Second function returns an integer representing the second component of a specified date and time.

Syntax

Second(date)

Function arguments:

  • date (required) - the date or column containing date values from which the second component is extracted

Example

Second(Date("2007-08-14 07:11:05"))

Extracts the second component from the specified date and time and returns 5 to represent five seconds into the eleventh minute of the hour.