epoch
A moment written as a whole number counting seconds, milliseconds or microseconds since the Unix epoch. You'd meet milliseconds from JavaScript and Java, and microseconds in tracing systems such as Jaeger and Zipkin.
3 epoch types: none a sibling also accepts.
The 3 epoch types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Unix Timestamp (microseconds) unix_microseconds · TIMESTAMP | 1705312200000000 | — |
Unix Timestamp (milliseconds) unix_milliseconds · TIMESTAMP | 1705312200000 | — |
Unix Timestamp (seconds) unix_seconds · TIMESTAMP | 1705312200 | — |
Which epoch type is it?
1 of 3 epoch types accepts it.
| Type | Reads it as |
|---|---|
Unix Timestamp (microseconds) unix_microseconds | 2024-01-15 09:50:00+00 |
Use it
Shell
printf '%s\n' '1705312200000000' '1577836799999999' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('1705312200000000'), ('1577836799999999')) t(v);After 1577836799999999, one type remains: unix_microseconds.