Microsecond / Temporal Layer

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

Precision comparison:

DateTime Value	Microseconds	Note
2024-01-15 12:30:45.123456	123456	Full precision
2024-01-15 12:30:45.000001	1	Minimum non-zero
2024-01-15 12:30:45.000000	0	Exact second

Common applications:

Database query performance
Application response times
Network latency analysis
Process duration measurement
System call timing

Table

Transforms

[, ...]

Select

column

Datetime column with at least microsecond precision. Source should have sufficient precision for meaningful microsecond 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.