Date-Time Converter
Convert a date or timestamp into ISO 8601, Unix timestamp, UTC, SQL, and locale formats all at once.
Recommended Settings
Pro Tips
- •Paste a Unix timestamp in either seconds or milliseconds - the tool automatically detects which based on the number of digits
- •Almost any recognizable date string works as input, including ISO 8601, RFC 2822, and common locale formats
- •The SQL DATETIME format matches what MySQL, PostgreSQL, and most databases expect for a DATETIME or TIMESTAMP column
- •Local Date/Time values use your browser's own timezone - reload after changing your system timezone to see it reflected
Most Popular
Most developers convert a Unix timestamp to ISO 8601 or a human-readable local date/time
When to Use This Tool
Turn a raw Unix timestamp from an API response or log file into a readable date.
Get a properly formatted SQL DATETIME string for a WHERE clause or INSERT statement.
See the same instant expressed in every common format side by side.
Check whether a timestamp is in seconds or milliseconds by seeing which produces a sensible date.
How It Works
Parse your input as either a Unix timestamp (auto-detecting seconds vs. milliseconds) or a standard date string
Build a JavaScript Date object from the parsed value
Format that single Date object into ISO, UTC, SQL, and locale representations simultaneously
100% Private
Files never leave your device. All processing happens locally in your browser.
Lightning Fast
Powered by Client-side JavaScript Date parsing and formatting for optimal performance on modern browsers.
Open Source
Built with verified, open-source libraries. Fully transparent.
Frequently Asked Questions
How does it know if my timestamp is in seconds or milliseconds?
Timestamps in seconds for recent dates are 10 digits, while millisecond timestamps are 13 digits. The tool checks the magnitude of the number and treats anything larger than roughly 10 billion as milliseconds.
What date formats can I type in?
Anything JavaScript's native Date parser understands, including ISO 8601 (2024-01-15T10:30:00Z), RFC 2822 (Mon, 15 Jan 2024 10:30:00 GMT), and common formats like 'January 15, 2024'.
Why does the local time look different from UTC?
Local Date/Time and Local Time reflect your browser's configured timezone, while UTC String and ISO 8601 are always in Coordinated Universal Time.
Is my date data sent anywhere?
No, all parsing and formatting happens locally in your browser using standard JavaScript.