HOUR() FUNCTION
The MySQL HOUR function is used to extract the hour value from a date or datetime value. The various versions of MySQL support the HOUR function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.
Syntax:
HOUR( expression )
Parameters:
expression: It is used to specify the date or datetime value.
Example 1:
mysql> SELECT HOUR ('2019-07-05 15:30:20');
Output:
15
Explanation:
The HOUR value has been extracted from the datetime value.
Example 2:
mysql> SELECT HOUR ('15:30:20');
Output:
15
Explanation:
The HOUR value has been extracted from the time value.