MariaDB: HOUR Function
This MariaDB tutorial explains how to use the MariaDB HOUR function with syntax and examples.
Description
The MariaDB HOUR function returns the hour portion of a date value.
Syntax
The syntax for the HOUR function in MariaDB is:
HOUR( date_value )
Parameters or Arguments
- date_value
- A time or datetime value from which to extract the hour.
Note
- The HOUR function returns the hour (a number ranging from 0 to 838) given a date value.
- Since a time value can range from -838:59:59' to '838:59:59', the HOUR function can return values up to 838 (ie: higher than 23).
- See also the EXTRACT, YEAR, QUARTER, MONTH, WEEK, DAY, MINUTE, SECOND, and MICROSECOND functions.
Applies To
The HOUR function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB HOUR function examples and explore how to use the HOUR function in MariaDB.
For example:
SELECT HOUR('2014-05-19 09:11:18.000004'); Result: 9 SELECT HOUR('2014-05-19 14:17:05'); Result: 14 SELECT HOUR('12:05:06'); Result: 12 SELECT HOUR('838:59:59'); Result: 838
This last HOUR example would display the hour portion of the current system time (current system time is returned by the CURTIME function).
SELECT HOUR(CURTIME());
Advertisements