Syntax

HOUR(<date>)

Description

Returns only the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Examples

Column1

HOUR returns

Aug 2, 2011 3:55:03 PM

15

Aug 31, 2011 11:30:47 AM

11

Apr 12, 1978 12:05:08 PM

12