Multi-Format Time Converter

Convert timestamps across ISO 8601, RFC 2822, Unix seconds, milliseconds, and SQL formats.

Supported: Unix timestamp (s/ms), ISO 8601, RFC 2822, HTTP date, etc.

Placeholders: YYYY (year) MM (month) DD (day) HH (24h) hh (12h) mm (min) ss (sec) SSS (ms) A/a (AM/PM)

ISO 8601
2026-11-19T12:21:08.213Z

International standard date-time format

RFC 2822
Fri, 19 Nov 2026 12:21:08 +0000

Email standard format

HTTP Date
Thu, 19 Nov 2026 12:21:08 GMT

HTTP date header format

SQL DateTime
2026-11-19 12:21:08

SQL database date-time format

SQL Timestamp
2026-11-19 12:21:08.213

SQL timestamp format (with milliseconds)

Unix timestamp (seconds)
1795090868

Unix timestamp in seconds

Unix timestamp (milliseconds)
1795090868213

Unix timestamp in milliseconds

Excel Serial
46345.514678

Excel date serial number

Julian Date
2461364.51467593

Julian day

Local time
11/19/2026, 12:21:08 PM

Browser's local time zone

Custom format
2026-11-19 12:21:08

User-defined format

About Multi-Format Time Converter — Detailed Guide

Category: Date & Time 100% Browser-Local

The Multi-Format Time Converter translates any epoch timestamp or date string into ISO 8601, RFC 2822, HTTP Date, SQL DateTime, SQL Timestamp, Unix seconds/milliseconds, Excel Serial Date, Julian Date, and custom pattern formats simultaneously.

Designed for backend, frontend, and data engineers reconciling timestamps across HTTP headers, databases, and spreadsheets, all conversions execute locally in the browser.

#time #date #format #iso #rfc #timestamp #convert

Key Features & Capabilities

  • Simultaneous conversion to ISO 8601, RFC 2822, HTTP Date, and SQL formats
  • Includes specialized conversions for Excel Serial numbers and Julian Dates
  • Supports custom format templates (e.g., YYYY-MM-DD HH:mm:ss) with live preview
  • Auto-parses epoch integers or date strings with individual one-click copy buttons

How to Use

  1. 1

    Enter an epoch timestamp or date string, or click Now to load the current instant.

  2. 2

    Optionally adjust the custom format string to preview your own pattern.

  3. 3

    Copy any of the generated standard formats from the result grid below.

Common Use Cases

  • → Debugging HTTP caching headers such as Expires and Last-Modified
  • → Translating numeric Excel serial date cells into human-readable SQL or ISO formats
  • → Validating timestamp consistency across logs, APIs, and database dumps

Related Tools

Frequently Asked Questions & Privacy

What input formats are accepted?

You can enter 10-digit seconds, 13-digit milliseconds, ISO 8601 strings, or standard parseable date strings.

What is the Excel Serial output?

Spreadsheets store dates as sequential day numbers starting from December 30, 1899; this tool computes that exact numeric value.