● Live Β· Real-time engine

Date Time Conversion, every format, one submit.

Paste any date, timestamp or ObjectId and get instant, accurate conversions across ISO 8601, RFC 3339, RFC 7231, Unix time, MongoDB ObjectId, SQL, Excel serial and a dozen more β€” single entries or bulk lists.

ISO 8601 RFC 3339 RFC 7231 Unix Timestamp MongoDB ObjectId Bulk CSV Export

Right now, everywhere

ISO 8601β€”
Unix (seconds)β€”
RFC 7231 (HTTP)β€”
Local timeβ€”

Auto-detects ISO 8601, Unix seconds/ms, RFC 2822, RFC 7231, MongoDB ObjectId, or free text like "now". βœ“ recognized

Applies to local-time style outputs only.

Up to 500 lines. Blank lines are ignored; unparsable lines are flagged in the results table.

Conversion Results

πŸ’¬ Send feedback
Capabilities

Built for every format you'll actually hit

From API debugging to database migrations, the converter covers the formats developers, analysts and support teams run into daily.

⏱

15+ output formats

ISO 8601, RFC 3339, RFC 7231, RFC 2822, Unix (s/ms), SQL, Excel serial, Julian date and more, generated in one pass.

🧠

Auto-format detection

Paste almost anything β€” a timestamp, an ISO string, an HTTP date, or a MongoDB ObjectId β€” and the parser figures out the rest.

πŸ“‹

Bulk conversion

Convert up to 500 values at once from a pasted list, then export the full table as CSV or TXT.

🌍

Timezone aware

Render local-time outputs in any IANA timezone without leaving the page.

πŸ†”

MongoDB ObjectId decoding

Extract the embedded creation timestamp from any ObjectId, or generate one from a chosen date.

⚑

Instant, client-side

All parsing and formatting runs in your browser β€” no server round-trip, no data leaves your device.

Process

How it works

01

Paste a value

Enter a date, timestamp, HTTP header value or ObjectId β€” or switch to Bulk and paste a whole list.

02

Convert

Click Convert. The submit button disables while formats are computed, then re-enables automatically.

03

Review results

The page scrolls to the results card showing every format side by side, or a full bulk table.

04

Copy or export

Copy any single value, copy everything at once, or download the full set as CSV or TXT.

Guide

Date time conversion, explained simply

Every system on the internet keeps time a little differently, and that mismatch is where most date bugs come from. A server might log a Unix timestamp like 1755511800, a browser might render a human-friendly local string, and an API response might arrive as ISO 8601: 2026-08-18T10:30:00Z. None of these are wrong β€” they're just different dialects for the same instant in time. A date time converter exists to translate between them instantly, so you don't have to do the math by hand or trust a snippet copied from a forum thread.

ISO 8601 is the closest thing the world has to a universal date format. It orders fields from largest to smallest β€” year, month, day, hour, minute, second β€” which keeps dates sortable as plain text and removes the ambiguity between region-specific patterns like 08/09/2026, which could mean August 9 or September 8 depending on where you're reading it. RFC 3339 is essentially ISO 8601 tightened for internet use: it insists on a fixed structure with an explicit UTC offset, which is why you'll see it required in API specs, log formats and JSON schemas. RFC 7231, by contrast, is the HTTP-date format used specifically in web headers such as Last-Modified and Expires β€” it looks like Wed, 21 Oct 2026 07:28:00 GMT and every browser and cache server expects that exact shape.

Unix timestamps solve a different problem: instead of describing a date in words, they count elapsed seconds (or milliseconds) since January 1, 1970 UTC, the so-called Unix epoch. That single number is timezone-free and trivially easy to compare or sort in code, which is why databases, logging systems and message queues favor it internally, even though it's unreadable to a human glancing at a table.

Document databases add their own twist. A MongoDB ObjectId is a 12-byte identifier, and the first four bytes are literally a Unix timestamp marking when the document was created. That means you can look at any _id field and, without querying anything else, know the exact second a record was inserted β€” which is exactly what the ObjectId decoder above does.

Knowing how to convert date time between these formats matters most at the boundaries: when a frontend needs to display a friendly local time from a UTC timestamp, when a data pipeline needs to normalize mixed-format logs before analysis, or when a support engineer needs to confirm whether a cache header actually expired. Rather than writing throwaway scripts for each case, a converter that recognizes the input format automatically and produces every common output at once turns a five-minute debugging detour into a five-second lookup β€” accurate, repeatable, and free of the timezone mistakes that manual conversion tends to introduce.

FAQ

Frequently asked questions

ISO 8601 is an international standard for representing dates and times, written as YYYY-MM-DDTHH:mm:ss.sssZ. It removes ambiguity between region-specific formats like MM/DD/YYYY and DD/MM/YYYY and is the default format used across databases, APIs and programming languages.

A Unix timestamp counts seconds (or milliseconds) since January 1, 1970 UTC. Paste the number into the converter above, and the auto-detector recognizes it and instantly outputs the equivalent date in ISO 8601, RFC 3339, local time and a dozen other formats.

RFC 3339 is a stricter profile of ISO 8601 built for internet protocols. Every RFC 3339 timestamp is valid ISO 8601, but RFC 3339 requires a fixed structure β€” a T separator plus an explicit offset or Z β€” while ISO 8601 permits more variations such as week dates and ordinal dates.

The first four bytes of every MongoDB ObjectId encode the creation time as a Unix timestamp in seconds. This converter decodes that segment so you can see exactly when a document was inserted, and can generate a placeholder ObjectId from any date you enter.

RFC 7231 defines the HTTP-date format used in headers like Last-Modified, Expires and Date, written as "Wed, 21 Oct 2026 07:28:00 GMT". Web servers, browsers and caching proxies all rely on this exact format to negotiate freshness of content.

Need more than dates?

Explore the full Time Tools collection or browse 100+ free AI-powered utilities built for the same no-nonsense workflow.