ColumnOperator / Temporal Layer

Perform element-wise addition or subtraction between datetime and duration columns, similar to pandas datetime arithmetic or SQL DATEADD with dynamic intervals.

Example operations:

Base DateTime	Operation	Duration	Result DateTime	Use Case
2024-01-15 10:00:00	Add	2h30m	2024-01-15 12:30:00	Meeting end
2024-01-15 12:00:00	Sub	4h	2024-01-15 08:00:00	Shift start
2024-03-01 00:00:00	Add	90d	2024-05-30 00:00:00	Contract end
2024-12-31 23:59:59	Sub	365d	2023-12-31 23:59:59	Year ago

Common applications:

Event scheduling
SLA calculations
Session timing
Dynamic intervals
Process monitoring
Variable timeframes

Note: Operations handle calendar complexities like month lengths, leap years, and daylight savings transitions automatically.

Table

SelectFirst

column

Base datetime column for operations. This column provides the reference points from which durations will be added or subtracted. Must be date, time, or datetime type.

Operator

enum

Add

Arithmetic operation to perform between datetime and duration columns.

Add ~

Add durations to move forward in time. Use cases:

Calculate end times from start times and durations
Project future dates based on intervals
Determine deadline dates from task durations

Sub ~

Subtract durations to move backward in time. Use cases:

Find start times from end times and durations
Calculate historical dates from reference points
Determine inception dates from known durations

SelectSecond

column

Duration column containing time intervals. Each row specifies how far to move from the corresponding base datetime. Must be duration type compatible with the operation.

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.