Nanosecond / Temporal Layer

Extract nanosecond component (10⁻⁹ seconds) from datetime values, similar to Python's datetime.nanosecond. Returns values from 0 to 999,999,999.

Precision comparison:

DateTime Value	Nanoseconds	Note
2024-01-15 12:30:45.123456789	123456789	Full precision
2024-01-15 12:30:45.000000001	1	Minimum non-zero
2024-01-15 12:30:45.000000000	0	Exact second

Common applications:

High-frequency trading analysis
Scientific instrument readings
System performance profiling
Precise event sequencing
Hardware timing analysis

Table

Transforms

[, ...]

Select

column

Datetime column with nanosecond precision. Source should have sufficient precision for meaningful nanosecond extraction. Returns 0 for lower precision inputs.

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.