HOUR ^v2.6.131 ​

Returns the hour component of a given time value.

HOUR(time_value)

HOUR(time_value)

Parameters ​

• time_value - The time value from which to extract the hour component.

Examples ​

HOUR("13:30:45")

HOUR("13:30:45")

Result: 13

Note: Returns the hour component (13) of the given time value (13:30:45).

HOUR(0.75)

HOUR(0.75)

Result: 18

Note: Returns the hour component (18) of the given time value (0.75), which represents 6:00:00 PM.