HOUR

Returns the hours component of a time value as a number.

Syntax:

HOUR(time)

Example:

HOUR(23:59:58)

returns the number23.