TotalSeconds / Temporal Layer

Convert duration values to total seconds. Returns 64-bit integer count of complete seconds, similar to timedelta.total_seconds().

Duration conversion examples:

DurationTotal SecondsNote
00:01:0060One minute
01:00:003,600One hour
24:00:0086,400One day
00:00:01.5001Truncates subseconds

Common applications:

  • Process timing
  • Operation duration
  • Timeout calculations
  • Event intervals Range: ±292 billion years
Table
0
0
Table

Transforms

[, ...]

Select

column

Duration column to convert to seconds. Subsecond portions are truncated, not rounded. For fractional seconds, use higher precision conversions.

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.