HOUR

Returns the hour part of the datetime or time.

Syntax

HOUR(datetime)

Example

SELECT HOUR("2020-06-20 10:02:00");

The above query returns 10.