Second / Temporal Layer
Extract seconds from datetime values, similar to datetime.second in Python or EXTRACT(SECOND FROM timestamp) in SQL.
Output formats:
| Input Datetime | Integer | Float | Note |
|---|---|---|---|
| 2024-01-15 12:30:45 | 45 | 45.0 | Exact second |
| 2024-01-15 12:30:45.123 | 45 | 45.123 | With milliseconds |
| 2024-01-15 12:30:59.999 | 59 | 59.999 | Maximum value |
Common applications:
- Time-based aggregations
- Process duration analysis
- Time series binning
- Performance monitoring
- Schedule analysis
Table
0
0
Table
Transforms
[, ...]Select
columnDatetime column to extract seconds from. Handles both simple and fractional seconds. Values wrap from 59 back to 0 at minute boundaries.
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.