HOUR

Description

HOUR returns the hour component of the specified time in 24-hour format.

Syntax

HOUR ( serial_number )

Parameter	Description
serial_number	The time as a serial number. The decimal portion of the number represents time as a fraction of the day.

Remarks

The result is an integer ranging from 0 (12:00 AM) to 23 (11:00 PM).

Examples

This function returns 9:

HOUR(34259.4)

This function returns 23:

HOUR(34619.976)

Also, see