Timestamp / Temporal Layer
Convert datetime values to Unix timestamps (seconds since 1970-01-01 00:00:00 UTC) with specified precision. Similar to datetime.timestamp() or UNIX_TIMESTAMP().
Example conversions:
| DateTime (UTC) | Milliseconds | Microseconds | Nanoseconds |
|---|---|---|---|
| 2024-01-15 00:00:00 | 1705276800000 | 1705276800000000 | 1705276800000000000 |
| 1970-01-01 00:00:00 | 0 | 0 | 0 |
| 2024-01-15 12:30:45.123 | 1705321845123 | 1705321845123456 | 1705321845123456789 |
Common applications:
- System interoperability
- Log file processing
- Time series analysis
- Performance measurement
- Data synchronization
- Event ordering
Transforms
[, ...]Select
columnDateTime column to convert to timestamp. Input timezone affects the result - UTC timestamps are most common for consistency.
Unit
enumPrecision level for timestamp representation. Affects storage size and resolution.
Nanosecond precision (10⁻⁹ seconds). For high-precision scientific or technical measurements. 64-bit range: ~1678-2262.
Microsecond precision (10⁻⁶ seconds). For system-level timing. 64-bit range: ~1677-2262.
Millisecond precision (10⁻³ seconds). Most common for general use. 64-bit range: ~1677-2262.
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.