HOUR()
HOUR(time)
time
Returns the hour for time. This code returns the value 11:
11
SELECT HOUR('11:56:23');