Hour

Returns the hour component of the given Date as a number. Category: date Syntax:

Hour([date_column], |timezone|)

Returns: IntColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`date_column`	`column\|datetime`	✓ Yes	The Date from which to extract the hour component.
`timezone`	`text`	✗ No	Name of IANA time zone to get the date part at (e.g., “America/Los_Angeles”). When calculating a time zone, input dates are treated as UTC.

Allowed Column Types: DATETIME

Hour(Date("2007-08-14 07:11:00"))

Returns hour from the given date value. Result: 7

Hour([Date])

Returns the hour component of each date value in the [Date] column as a number.

Last modified on March 6, 2026