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>