Date Format Converter - Dates and Timestamps Online
Convert a date into ISO 8601, RFC 2822, US and UK formats, Chinese dates, Unix timestamps, Excel serials and ISO weeks, with custom patterns.
Last updated: 2026-11-15
Date Format Converter
Turn one moment into 16 common formats: ISO 8601, RFC 2822, US / UK / Chinese dates, Unix timestamps, Excel serial and ISO week, or write your own pattern and convert a whole list.
Accepts 2026-11-15, 2026/11/15, 2026.11.15, 20261115, 10- or 13-digit timestamps, and ISO strings with Z or +08:00. Inputs without a timezone are read as local time.
Affects the output only; input is still read as local time.
Supports yyyy, yy, MM, M, MMM, MMMM, dd, d, EEE, EEEE, HH, H, hh, h, mm, m, ss, s, SSS and a.
Format comparison
| Format | Value | Action |
|---|
Batch convert
One date or timestamp per line, formatted with the pattern above. Lines that cannot be parsed are flagged in the result.
How to use Date Format Converter
One moment, a dozen ways to write it. This converter shows ISO 8601, RFC 2822, US, UK and Chinese dates, Unix timestamps, Excel serial numbers and ISO weeks side by side, and can reformat a whole column with a custom pattern.
- 1
Enter a date
Paste 2026-11-15, 2026/11/15, 2026年11月15日, 20261115 or a 10- or 13-digit timestamp. The Now button fills in the current time.
- 2
Choose the output timezone
Keep local time for everyday use, or switch to UTC when comparing against a server log or a colleague in another timezone.
- 3
Read the comparison
Each row is one output format, from machine-readable ISO to a long English date. Copy any single row with its button.
- 4
Write a custom pattern
Tokens such as yyyy-MM-dd HH:mm or EEEE, MMMM d, yyyy build a template, and the first table row previews it live as you type.
- 5
Convert a batch
Paste a column of dates and press Convert. Lines that fail to parse are marked so you can fix them, up to 500 lines per run.
Key features
Many inputs accepted
Dashes, slashes, dots, Chinese year-month-day, compact eight digits, Unix seconds or milliseconds and ISO strings with an offset all parse without preprocessing.
Sixteen outputs at once
Machine formats and human formats sit in the same table, so you no longer bounce between three different tools.
Pattern playground
More than twenty tokens cover year, month, day, hour, minute, second, milliseconds, weekday, month names and the AM/PM marker.
Copy and batch
Copy one row or the whole table. Batch output pastes straight into a spreadsheet or a script.
Common use cases
API payloads
A backend expects ISO 8601 with an offset while your source data says 2026/11/15 21:30. Convert once and paste it into the request example.
Email headers
RFC 2822 is the format used in email Date headers, handy when building raw messages or debugging an odd timestamp.
Cleaning spreadsheets
Normalise a messy date column to yyyy-MM-dd before importing, so the spreadsheet stops guessing whether 03/04 means March or April.
Reading logs
Decide whether 1763213400 is seconds or milliseconds and see which day and timezone it refers to.
Chinese copywriting
When a page needs 2026年11月15日 星期六, copy the Chinese date row instead of typing it by hand.
Frequently asked questions
How are dates without a timezone read?
As wall-clock time in your own timezone. Inputs that declare Z or an offset are parsed as that instant, then displayed in the output timezone you selected.
Seconds or milliseconds?
Ten digits are treated as seconds and thirteen as milliseconds. Eight-digit numbers are read as yyyyMMdd dates first, so 20261115 is not mistaken for a timestamp.
What is the Excel serial number?
Excel counts days from 1899-12-30, with the fractional part as the time of day. Paste the value into a date-formatted cell to see the date. It is computed for the wall-clock time of the selected timezone.
How does the ISO week differ from a normal week?
ISO weeks start on Monday, and week 1 is the week containing January 4. Around New Year the ISO year can differ from the calendar year, so the row shows ISO year-Wweek-day.
Will M and m be confused?
No. MM and M mean month, while mm and m mean minutes. HH is 24-hour and hh is 12-hour, a prints the AM/PM marker, and EEE or EEEE gives the weekday.
What is the batch limit?
500 lines per run. Anything beyond that is skipped and reported in the summary so the page stays responsive.
Is my data uploaded?
No. Parsing and formatting run entirely in the browser, and reloading the page clears the inputs.
Related tools
Currency Converter
Convert 160 currencies at the daily rate. Type an amount, pick two currencies and read the result with a reference table, plus a manual mode for offline use.
Business Day Calculator
Count working days between two dates while skipping weekends, add your own holidays and make-up workdays, and find the date N business days away.
24 Solar Terms
Free table of the 24 Chinese solar terms for any year 2024-2037, with Gregorian dates and exact Beijing-time moments, today's term highlighted and a countdown to the next.
Length Converter
Free length converter: enter one value and see millimeters, centimeters, meters, kilometers, inches, feet, yards, miles, nautical miles and Chinese chi at once.
Weight Converter
Free weight converter: enter one value and see milligrams, grams, kilograms, tonnes, ounces, pounds, stones, US tons and Chinese jin and liang at once.
Area Converter
Free area converter: enter one value and see square meters, square kilometers, hectares, Chinese mu, square feet, square yards, acres and square miles at once.
Volume Converter
Free volume converter: enter one value and see milliliters, liters, cubic meters, US and imperial gallons, cups, tablespoons, teaspoons and cubic feet at once.
Data Storage Converter
Free data storage converter: enter one value and see bits, bytes, KB, MB, GB, TB plus KiB, MiB, GiB and TiB at once, with decimal and binary units kept apart.
China Income Tax Calculator
Estimate China's individual income tax with current seven brackets: annual filing, monthly withholding, annual bonus comparison and service fees.
Chinese Amount in Words
Free converter that turns a numeric amount into standard Chinese uppercase for invoices and cheques, with correct zero readings, jiao and fen handling and rounding to the cent.
