HOUR

Date/Time Functions:
Function: HOUR() - Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 AM) to 23 (11:00 PM).
(E1): 00:06:00
Hour is: 0
(E2): 01:12:15
Hour is: 1
(E3): 03:30:12
Hour is: 3
(E4): 05:17:31
Hour is: 5
(E5): 08:15:45
Hour is: 8
(E6): 12:45:11
Hour is: 12
(E7): 14:00:30
Hour is: 14
(E8): 17:55:50
Hour is: 17
(E9): 19:21:08
Hour is: 19
(E10): 21:10:10
Hour is: 21
(E11): 23:59:59
Hour is: 23