Date Time Converter
Real-time conversion tool for multiple date and time formats
JS Locale String
Local time format
ISO 8601
International standard
ISO 9075
SQL standard format
RFC 3339
Internet time format
RFC 7231
HTTP date format
Unix Timestamp
Seconds since epoch
Timestamp
Milliseconds since epoch
UTC Format
Coordinated Universal Time
MongoDB ObjectID
MongoDB document ID
Excel Date/Time
Excel serial number
Date & Time Format Knowledge
What is ISO 8601 Format?
ISO 8601 is an international standard for representing dates and times. The format is YYYY-MM-DDTHH:mm:ss.sssZ, where T separates the date and time, and Z indicates UTC time. For example: 2023-07-21T14:30:00Z. This format is widely used in computer systems and internet protocols.
What is a Unix Timestamp?
A Unix timestamp represents the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC, excluding leap seconds. It is widely used in Unix and Unix-like systems, as well as in many programming languages to represent time. The millisecond timestamp represents the same duration in milliseconds.
Difference Between RFC 3339 and ISO 8601
RFC 3339 is a date and time format standard published by the Internet Engineering Task Force (IETF). It is essentially a subset of ISO 8601. RFC 3339 requires the use of full date and time (including timezone information) in the format YYYY-MM-DDTHH:mm:ss[±]HH:mm. It more specifically defines how date and time should be represented in internet applications.
How Excel Date/Time Format Works
Excel uses a serial number system to represent dates and times. The integer part represents the number of days since January 1, 1900 (Windows) or January 1, 1904 (Mac). The fractional part represents the time of day as a fraction. For example, 1.5 represents noon on January 1, 1900. In Excel, dates and times can be mathematically manipulated like ordinary numbers.
What Information Does MongoDB ObjectID Contain?
MongoDB's ObjectID is a 12-byte hexadecimal string that contains:
- 4 bytes: Unix timestamp (in seconds)
- 5 bytes: Randomly generated value
- 3 bytes: Incrementing counter
Date Time Conversion FAQs
What date and time formats does this converter support?
Our tool supports conversion between JS Locale String, ISO 8601, ISO 9075, RFC 3339, RFC 7231, Unix timestamp, millisecond timestamp, UTC format, MongoDB ObjectID, and Excel date/time formats.
Is this converter free to use?
Yes, this is a 100% free online tool. No registration or subscription is required to use all features. Our date time converter is completely free with no hidden fees.
Is my data saved when I use this converter?
No, all date time conversions are performed in your browser. Your data is never sent to any server, ensuring your privacy. We designed this online tool with a strong focus on user privacy protection.
How do I use this conversion tool?
Enter a date/time value in any format's input field, and the other formats will update automatically. For example, enter "1690000000" in the Unix timestamp field to see all other formats update to the corresponding time. You can also use the "Use Current Time" button to quickly get the current time.
Does this tool work on mobile devices?
Yes, our date time converter is fully responsive and works perfectly on phones, tablets, and desktop devices. Wherever you are, you can perform date time conversions anytime.