HOUR() FUNCTION in MySQL

HOUR() FUNCTION
The MySQL HOUR function is used to extract the hour value from a date or datetime value. The various versions of MySQL supports 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.

Please Share