Timestamp2 knowledge base

The Unix Time Field Guide

A practical tour of epoch units, portable date formats, time-zone behavior and everyday developer workflows.

Where epoch conversion earns its keep

API payloads and webhooks

Turn created_at, updated_at, expires_at, iat, nbf and exp fields into readable moments while tracing REST, GraphQL, JWT and webhook data.

Logs and incident timelines

Make sense of server logs, app events, audit records, telemetry, analytics and monitoring alerts without leaving the browser.

SQL and stored data

Verify epoch columns from PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, BigQuery, Snowflake, Redis and document stores.

Code in every stack

Cross-check values emitted by JavaScript, TypeScript, Python, Java, PHP, Go, Ruby, Rust, C#, C++, Kotlin and Swift.

DevOps and cloud systems

Decode shell output, file times, cron runs, containers, CI/CD jobs, infrastructure events and cloud automation records.

Data work and spreadsheets

Standardize dates for CSV exports, Excel, Google Sheets, ETL pipelines, warehouses, reports and analytics dashboards.

Auth and security checks

Inspect token expiry, session duration, signed requests, access logs and any authorization rule that depends on time.

Ledgers and event streams

Translate block times, transactions, queue messages, distributed events and stream records into human-friendly dates.

Time formats understood by Timestamp2

Epoch, ISO and local date formats available in Timestamp2
FormatExampleWhat it means
Unix seconds1704067200The familiar 10-digit scale used across Unix, Linux, APIs and databases.
Unix milliseconds1704067200000The 13-digit precision common in JavaScript, Java and event pipelines.
ISO 8601 / RFC 33392024-01-01T00:00:00ZA portable text date for JSON, APIs, logs and system-to-system exchange.
Local date and time2024-01-01 02:00:00A wall-clock reading interpreted using the time zone you choose.
UTC, GMT and IANA zonesUTC · GMT+2 · Europe/SofiaFixed offsets plus location-aware time-zone and daylight-saving rules.

Three steps across the timeline

  1. Drop in an epoch value, select seconds or milliseconds, then choose where in the world to display it.
  2. For the reverse trip, set a wall-clock date and tell Timestamp2 which time zone that clock belongs to.
  3. Copy the readable date, ISO 8601 string, epoch seconds or epoch milliseconds you need.
Launch the Unix time machine