MySQL Function Reference

HOUR

Returns the hour value (between 0 and 23) for the time

MySQL 8.1

HOUR(datetime)

Examples

MySQL 8.1

SELECT HOUR('2022-06-16 16:37:03');