Returns the hour component of the given date as a number.


Hour(date, [timezone])

date (required) The date from which to extract the hour component.

timezone (optional) Name of IANA timezone to get the date part at, e.g. “America/Los_Angeles”. When calculating a timezone, input dates are treated as UTC.


Hour(Date("2007-08-14 07:11:00"))
  • Returns 7.

See Also