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
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.