SECOND

SECOND(time)[source]

Extracts the second component from a time or array of times.

The SECOND function returns the second from the provided time. It supports both single times and arrays of times, returning an integer or an integer array accordingly.

Parameters:

time (Operand) –

The time or array of times from which to extract the hour.

Supported types:

  • TIME

  • DATETIME

  • TIME_ARRAY

  • DATETIME_ARRAY

Return type:

Formula

Returns:

The second as an integer or array of integers.

Supported types:

  • INTEGER

  • INTEGER_ARRAY

Raises:

ValueError – If the input is not a time type.

Examples

SECOND(TIME(14, 32, 53))
# Returns 53