HOUR

HOUR(time)[source]

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

The HOUR function returns the hour 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 hour as an integer or array of integers.

Supported types:

  • INTEGER

  • INTEGER_ARRAY

Raises:

ValueError – If the input is not a time type.

Examples

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