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:
Duration | Total Seconds | Note |
---|---|---|
00:01:00 | 60 | One minute |
01:00:00 | 3,600 | One hour |
24:00:00 | 86,400 | One day |
00:00:01.500 | 1 | Truncates subseconds |
Common applications:
- Process timing
- Operation duration
- Timeout calculations
- Event intervals Range: ±292 billion years
Table
0
0
Table
Transforms
[, ...]Select
columnDuration column to convert to seconds. Subsecond portions are truncated, not rounded. For fractional seconds, use higher precision conversions.
AsColumn
nameName 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.