CodesJava

Easy learning with example program codes

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 follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status