Skip to main content
Returns the hour component of the given Date as a number. Category: date Syntax: 
Hour([date_column], |timezone|)
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
date_columncolumn|datetime✓ YesThe Date from which to extract the hour component.
timezonetext✗ NoName 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

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

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 13, 2026