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 Value | Milliseconds | Note |
---|---|---|
2024-01-15 12:30:45.123 | 123 | Full precision |
2024-01-15 12:30:45.001 | 1 | Minimum non-zero |
2024-01-15 12:30:45.000 | 0 | Exact 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
columnDatetime column with at least millisecond precision. Source should have sufficient precision for meaningful millisecond extraction. Returns 0 for lower precision inputs.
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.