Date-time converter
Date Formats, Time Zones, and Timestamp Parsing
This tool converts a date/time string or timestamp into many different formats, including ISO, RFC, Unix timestamp, Mongo ObjectID, Excel date, and more. It helps you quickly see and copy the same moment in various representations.
- Unix timestamp (seconds or milliseconds)
- ISO 8601 (e.g. 2023-05-07T14:45:29+08:00)
- Locale string (e.g. Wed May 07 2025 14:45:29 GMT+0800)
- RFC 3339, RFC 7231
- Mongo ObjectID (24 hex chars)
- Excel date/time (days since 1899-12-30)
When "Auto detect" is selected, the tool tries to guess the input type based on its format. It checks for Mongo ObjectID, Excel date, timestamp, ISO, RFC, and locale string in order. The detected type is shown below the input.
- The input doesn't match the selected type's format
- The date is out of range or not a real date
- There are extra spaces or typos in the input
Related Tools
Useful tools selected for this workflow
Julian Date Converter
Convert between Gregorian calendar dates and Julian dates (ordinal date format). Julian date format uses yyddd or yyyyddd where yy/yyyy is the year and ddd is the day of year.
Discord Time Converter
Convert time to Discord time format.
Day Counter
Count the days between two dates, or find the date 30, 45, 60, or 90 days from today — with weekday, weekend, and business-day breakdowns.
Chronometer
Measure the time it takes to complete a task.
Time to Decimal Calculator
Convert time from hours:minutes:seconds format to decimal hours, minutes, or seconds instantly. Perfect for time to decimal conversion in payroll, timesheet, and billing calculations with 6 decimal precision.
Military Time Converter
Convert military time to standard time.