Unix Epochs & ISO-8601
Always store timestamps in UTC and format local timezones only at display boundaries.
Quick Conversion Recipes
# Current UTC ISO-8601
date -u +"%Y-%m-%dT%H:%M:%SZ"
# Epoch seconds to UTC (GNU / Linux)
date -u -d @1763600000 +"%Y-%m-%d %H:%M:%S UTC"
# Epoch seconds to UTC (macOS / BSD)
date -u -r 1763600000 +"%Y-%m-%d %H:%M:%S UTC"
| Precision | Digits | Example |
|---|---|---|
| Seconds | 10 | 1763600000 |
| Milliseconds | 13 | 1763600000000 |
| Microseconds | 16 | 1763600000000000 |