Quick reference

TopicValueUse
UTC instant2026-07-16T00:00:00ZPortable API timestamp
Offset time2026-07-16T08:00:00+08:00Local time with explicit offset
Date only2026-07-16Calendar date without time

Practical notes

Use a trailing Z when the value is UTC. Use an explicit offset such as +08:00 when preserving local clock time matters. Avoid unlabeled local date-time strings in API payloads.

ISO 8601 strings sort correctly only when they use a consistent format and timezone. Normalize storage values to UTC when the goal is ordering, comparison, or deduplication.

CheckWhy it matters
Unit labelField names such as created_at_ms or expires_at_s prevent seconds/milliseconds mixups.
TimezoneStore UTC or an explicit offset. Avoid server-local assumptions in jobs, logs, and API tests.
Round tripConvert timestamp to ISO and back before shipping a parser or migration script.

Open the Unix Timestamp Converter