MySQL Tutorial/Date Time Functions/HOUR
HOUR(time) returns the hour for time.
The range of the return value is 0 to 23.
The range of TIME values could be much larger.
<source lang="sql">
mysql> mysql> SELECT HOUR("10:05:03"); +------------------+ | HOUR("10:05:03") | +------------------+ | 10 | +------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT HOUR("272:59:59"); +-------------------+ | HOUR("272:59:59") | +-------------------+ | 272 | +-------------------+ 1 row in set (0.00 sec)</source>