How to use the HOUR function in MySQL

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!