Second
The Second function returns an integer representing the second component of a specified date and time.
For more information (including use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.
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.