DateTime Converter

Convert date and time into various formats including ISO 8601, RFC 3339, Unix timestamp, UTC format, Excel date/time, and more. Parse any date string and get all standard formats.

Date & Time Input

Put your date string here...

Parsed as: 1/1/9075, 12:00:00 AM•Timezone: UTC

Converted Formats

JS locale date string

JavaScript toLocaleString() format

Fri Jan 01 9075 00:00:00 GMT+0000 (Coordinated Universal Time)

ISO 8601

International standard date format

9075-01-01T00:00:00.000Z

ISO 9075

SQL standard date format

9075-01-01 00:00:00

RFC 3339

Internet date/time format

9075-01-01T00:00:00+00:00

RFC 7231

HTTP date format

Fri, 01 Jan 9075 00:00:00 GMT

Unix timestamp

Seconds since epoch

224212147200

Timestamp

Milliseconds since epoch

224212147200000

UTC format

Coordinated Universal Time

Fri, 01 Jan 9075 00:00:00 GMT

Mongo ObjectID

MongoDB ObjectId format

343415dc000000000000000000

Excel date/time

Excel serial date number

2620617

Supported Input Formats & Examples

ISO 8601:

2025-07-08T17:11:08.000Z
2025-07-08T17:11:08+03:00

SQL Format:

2025-07-08 17:11:08
2025/07/08 17:11:08

Human Readable:

July 8, 2025 5:11 PM
Jul 8, 2025 17:11:08

Unix Timestamp:

1751983868 (seconds)
1751983868605 (milliseconds)

RFC Formats:

Tue, 08 Jul 2025 14:11:08 GMT
2025-07-08T17:11:08+03:00

Excel Date:

45846.59107181713
45846 (date only)

Mongo ObjectID:

686d26fc0000000000000000
(first 8 chars are timestamp)

Common Formats:

07/08/2025
08-07-2025
2025.07.08