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.

Return type:

Formula

Returns:

The second as an integer or array of integers.

Raises:

ValueError – If the input is not a time type.

Examples

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

``value`` — accepted types

  • DATETIME

  • DATETIME_ARRAY

  • TIME

  • TIME_ARRAY

Return types

  • INTEGER

  • INTEGER_ARRAY