Time / Temporal Layer

Extract time component from datetime values as duration since midnight, similar to datetime.time() in Python or TIME() in SQL.

Example extractions:

DateTime Value	Time Component	Duration Since Midnight
2024-01-15 00:00:00	00:00:00	0 seconds
2024-01-15 12:30:45	12:30:45	45045 seconds
2024-01-15 23:59:59	23:59:59	86399 seconds
2024-01-15 15:45:30.500	15:45:30.500	56730.5 seconds

Common applications:

Daily pattern analysis
Time-based filtering
Schedule optimization
Operating hours analysis
Shift timing calculations
Time slot allocation

Table

Transforms

[, ...]

Select

column

DateTime column to extract time from. Returns time-of-day component as duration, preserving any sub-second precision in the source data.

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.