Date & Time Converter

Paste any date, time or timestamp — Unix seconds or milliseconds, ISO 8601, a Google Sheets date number — and see it in every common format and time zone.

Formats

Around the world

Custom format

Format tokens

YYYY: 2026
YY: 26
MMMM: November
MMM: Nov
MM: 11
M: 11
DD: 05
D: 5
Do: 5th
dddd: Sunday
ddd: Sun
HH: 09 (24-hour)
hh: 09 (12-hour)
h: 9
mm: 05
ss: 07
SSS: 123 ms
A: AM / PM
Z: +05:30
ZZ: +0530
X: Unix seconds
x: Unix ms
Q: Quarter
W: ISO week
[text]: kept as is

Add, subtract and compare

Difference from another date

Questions

How does it tell seconds from milliseconds?

By length: 10 digits are Unix seconds, 13 are milliseconds, 16 are microseconds, an 8-digit number like 20261115 is a compact date, and a five-digit number is read as a Google Sheets or Excel date. If the guess is wrong, change Read numbers as.

What is a Google Sheets or Excel date number?

Spreadsheets store dates as days since 30 December 1899, so 46341.5 is noon on 15 November 2026. Automations that read a sheet often receive this number instead of a date.

Why does a date without a time zone need one?

10:00 on 15 November is a different moment in Mumbai and in New York. When the input has no offset or Z, it is read in the time zone you pick under Input time zone.

Which tokens can I use in a custom format?

YYYY, MM, DD, HH, mm and ss for the parts of the date and time, MMM and MMMM for month names, ddd and dddd for weekday names, hh and A for 12-hour time, Z for the offset, and X or x for Unix seconds or milliseconds. Text in [brackets] is kept as it is.