Date-time converter
Frequently Asked Questions
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 You Might Like
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.
Case Converter
Convert the case of a string and choose between different formats such as lowercase, uppercase, camelcase, and more.
Color Converter
Convert colors between different formats such as hex, rgb, and hsl.
String to Slug
Convert a string to a slug.
Discord Time Converter
Convert time to Discord time format.
Base64 File Converter
Convert files to Base64 and decode Base64 strings back to files.