HOUR

Returns the hour component of a specific time as an integer

Usage examples 

  • HOUR("11:50")

  • HOUR(tableA.fieldB)

Syntax 

HOUR ( time_serial_num )

  • time_serial_num - the time from which to calculate the hour

Returns 

number - the hour of the time.

Functions reference