Home >Database >Mysql Tutorial >How to use the HOUR function in MySQL
How to use the HOUR function in MySQL
- WBOYforward
- 2023-05-26 14:22:551594browse
HOUR(time)
SELECT HOUR(‘11:22:33') SELECT HOUR(‘2016-01-16 11:22:33')
-> 11 -> 11
Returns the hour value of the date or time, value range (0-23)
The above is the detailed content of How to use the HOUR function in MySQL. For more information, please follow other related articles on the PHP Chinese website!
Statement：
This article is reproduced at:yisu.com. If there is any infringement, please contact admin@php.cn delete
Previous article：What data query statements are there in MySQL?Next article：What data query statements are there in MySQL?