HOUR

Syntax:

HOUR(time)

Returns the hours component of time as a number.

Example:

HOUR(23:59:58)

returns the number23.