Activity Feed
| Action date | User input | Converted date |
| 1 hour from now | now | Oct 14, 2024 13:57:06 |
| 1 hour from now | now | Oct 14, 2024 13:28:29 |
| 1 day ago | 2018-08-28T19:27:29+00:00 | Aug 28, 2018 19:27:29 |
| 1 day ago | 2018-08-28T19:27:29+00:00 | Aug 28, 2018 19:27:29 |
| 3 days ago | 2019-09-03T14:32:52Z | Sep 03, 2019 14:32:52 |
| 3 days ago | 2019-09-03 | Sep 03, 2019 00:00:00 |
| 3 days ago | 2019-009-03 | Jan 09, 2019 00:00:00 |
| 3 days ago | 2019-02-03 | Feb 03, 2019 00:00:00 |
| 3 days ago | Thu, 10 Oct 2024 20:03:30 +0000 | Oct 10, 2024 20:03:30 |
| 4 days ago | 133730316824180650 | Oct 10, 2024 11:01:22 |
Date Time Format Converter
DFormat.com is a tool that allows you to format dates into various standard formats. Formatting dates is important because different countries and applications use different date formats.
How does the Date-Time Format Converter work?
Just paste the date in any format into the input field and click "Convert." If we're able to detect the format and convert the date, you'll be redirected to a page with detailed information. Otherwise, you'll land on an error page.
What are the common date formats?
The most popular standards are:
- ISO 8601
- RFC 3339
- RFC 822 / RFC 2822
- RFC 7231
- ISO 9075
| Format | Mask | Description | Example |
|---|---|---|---|
| ISO 8601 | YYYY-MM-DD'T'HH:MM:SS±hh:mm | International standard for representing date and time. Widely used in web services, programming, and data exchange. | 2001-01-01T22:40:30 |
| ISO 8601 (Week) | YYYY-Www-D | Used in planning and reporting | 2024-W37-5T14:30:15 |
| RFC 3339 | YYYY-MM-DD'T'HH:mm:ss'Z' | Used in Internet protocols | 2001-01-01T22:40:30Z |
| RFC 822 / RFC 2822 | ddd, DD MMM YYYY HH:mm:ss 'GMT' | Used in email protocols | Mon, 01 Jan 2001 22:40:30 GMT |
| RFC 7231 | Day, DD Mon YYYY HH:MM:SS GMT | The format aligns with RFC 822, but RFC 7231 specifies and standardizes its use in HTTP | Mon, 09 Sep 2024 08:47:13 GMT |
| UNIX Time (Epoch Time) | Seconds since January 1, 1970 | Widely used in programming | 1694268615 |
| ISO 9075 | YYYY-MM-DD HH:MM:SS | A standard related to SQL query language | 2024-09-13 14:30:15 |
| Country | |||
| USA | MM/DD/YYYY HH:MM:SS | Date format commonly used in the USA | 12/01/2024 10:22:34 |
| British/French, EU | DD/MM/YY HH:MM:SS | Date format commonly used in Europe | 01/12/2024 10:22:34 |
| German | DD.MM.YYYY HH:MM:SS | Date format commonly used in Germany | 01.12.2024 10:22:34 |
| Italian | DD-MM-YYYY HH:MM:SS | Date format commonly used in Italy | 01-12-2024 10:22:34 |
| Japan | YYYY/MM/DD HH:MM:SS | Date format commonly used in Japan | 2024/12/01 10:22:34 |
| Chinese Date | SS (Animal) (M'th month), D, YYYY | Format used to represent dates in the Chinese lunisolar calendar | Gui-You (Rooster) (8th month), 7, 4722 |
| Other | |||
| Excel date/time | Dates and times in Excel are stored as floating-point numbers | Used internally by Excel to enable easy calculations with dates and times | 45544.3669174074 |
| Microsoft Timestamp / FileTime | 100-nanoseconds since Jan 1, 1601 | Used in Windows system APIs for file and directory timestamp handling | 128596303500000000 |
| Text Date | MMM DD, YYYY HH:MM:SS | Textual representation of a date | Jan 1, 2001 8:40:29 |
| Mac Timestamp | Seconds since January 1, 2001 | Date and time format used in macOS | 978310830 |
| Mongo ObjectID | 12-byte hexadecimal number | Unique identifier format used in MongoDB | 507f1f77bcf86cd799439011 |
| Julian Date | Number of days since January 1, 4713 BC | Date format used in astronomy | 2451911 |
| Julian Day Number | JDN.FFFFF | For precise time measurement, especially in astronomical observations | 2451910.44479 |