Millisecond / Temporal Layer

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

Precision comparison:

DateTime ValueMillisecondsNote
2024-01-15 12:30:45.123123Full precision
2024-01-15 12:30:45.0011Minimum non-zero
2024-01-15 12:30:45.0000Exact second

Common applications:

  • Web response time analysis
  • User interaction timing
  • Animation frame timing
  • API performance monitoring
  • Event logging systems
Table
0
0
Table

Transforms

[, ...]

Select

column

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