Skip to main content
Returns an integer representing the second component of a specified date and time. Category: date Syntax: 
Second([date_column])
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
date_columncolumn|datetime✓ YesThe date or column containing date values from which the second component is extracted.
Allowed Column Types: DATETIME

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Second(Date("2007-08-14 07:11:05"))
Extracts the second from the specified date and time. Result: 5 
Second([Date])
Returns the second component for each value in the [Date] column.
Last modified on March 13, 2026