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 |