Timestamp reference

Unix Timestamp Guide

Learn Unix timestamp formats, epoch conversion steps, timezone behavior and common developer use cases.

Common timestamp converter uses

APIs, JSON and webhooks

Decode created_at, updated_at, expires_at, iat, nbf and exp values while debugging REST APIs, GraphQL responses, JWTs and webhook payloads.

Logs and observability

Read timestamps from server logs, application events, analytics, telemetry, monitoring alerts, audit trails and incident timelines.

Databases and SQL

Check epoch fields used by PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, BigQuery, Snowflake, Redis and document databases.

Programming languages

Verify time values from JavaScript, TypeScript, Python, Java, PHP, Go, Ruby, Rust, C#, C, C++, Kotlin and Swift applications.

Linux, DevOps and cloud

Inspect Unix shell output, file modification times, cron jobs, containers, CI/CD pipelines, cloud events and infrastructure automation.

Data and spreadsheets

Normalize dates for CSV files, Excel, Google Sheets, ETL jobs, data warehouses, reporting tools and analytics dashboards.

Security and authentication

Review token expiration, session lifetimes, signed requests, access logs, security events and time-based authorization rules.

Blockchain and distributed systems

Translate block times, transaction events, message queues, event streams and distributed-system records into readable dates.

Supported timestamp formats and conversions

Common date and epoch formats supported by this tool
FormatExampleUse
Unix seconds1704067200Standard 10-digit epoch time used by Unix, Linux, APIs and databases.
Unix milliseconds170406720000013-digit timestamp used by JavaScript, Java and many event systems.
ISO 8601 / RFC 33392024-01-01T00:00:00ZPortable date format for JSON, APIs, logs and data exchange.
Local date and time2024-01-01 02:00:00Wall-clock time interpreted in the timezone you select.
UTC, GMT and IANA zonesUTC · GMT+2 · Europe/SofiaFixed offsets or location-based timezone and DST rules.

How to convert a timestamp or date

  1. Paste an epoch value, confirm seconds or milliseconds, and choose the output timezone.
  2. To convert the other way, enter a date and time and select the timezone in which it occurs.
  3. Copy epoch seconds, epoch milliseconds, the readable local date or the ISO 8601 value.
Open the timestamp converter