15.4.4 hour(date)

hour(date) function takes as an argument any one of the following data types: time interval or timestamp. The returned value represents the hour in the time represented by this date object. Returns a big integer indicating the hour of the time represented by this date.

Examples

Function Result

hour(12/06/17 09:15:22 AM)

09

hour(2015:07:21 12:45:35 PM)

12