HOUR

Returns the hour component of a time as number between 0-23.

Parameter List

Syntax
HOUR(time)
time

The time to extract the hour from. For example: 11:30:25 or 2020-02-02 20:30:30.

Examples

HOUR("20:30:30") returns 20