Hour / Temporal Layer

Extract hours from datetime values, similar to datetime.hour in Python or EXTRACT(HOUR FROM timestamp) in SQL. Returns integers from 0 to 23 in 24-hour format.

Example extractions:

Input Datetime	Hour	Common Name	Note
2024-01-15 00:30:45	0	12:30 AM	Midnight
2024-01-15 12:00:00	12	12:00 PM	Noon
2024-01-15 23:59:59	23	11:59 PM	End of day

Common applications:

Business hour analysis
Shift scheduling
Peak hour identification
Day/night pattern analysis
Time zone conversions

Table

Transforms

[, ...]

Select

column

Datetime column to extract hours from. Returns hour in 24-hour format, ignoring minutes and smaller units. Values wrap from 23 to 0 at day boundaries.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.