HOUR

Calculates the hour corresponding to a date/time value

HOUR( date )

Returns the hour for the given date/time element or array of dates. Hour is given as an integer, ranging from 0 (12:00AM) to 23 (11:00PM).

Arguments

Argument	Description
date	Date/time value(s)

Output

Hour of the day for each input date

Example