Date/timestamp converter

Right now

Timestamp1787180207
Timestamp in ms1787180207164
UTCWednesday 19 August 2026 at 22:56:47
Local timeThursday 20 August 2026 at 00:56:47 UTC+02:00 DST

This clock starts from the time measured on the server at page load, then advances with the time elapsed in your browser. It therefore does not show your own machine’s clock, which may drift. It is independent from the conversions below: converting does not touch it, and it erases no result.

Timestamp to date

The number of digits is enough to tell Unix scales apart: ten for seconds, thirteen for milliseconds, sixteen for microseconds, nineteen for nanoseconds. The other scales are picked from the list.

Date to timestamp

The day always comes first: 03/04/2026 is 3 April, never 4 March. The time zone says which offset the entered time is read in; it does not change the date shown in UTC.

The date

Timestamp
Timestamp in ms
UTC
Local time
ISO 8601

The same instant on the other scales

Unix — seconds
Unix — milliseconds
Unix — microseconds
Unix — nanoseconds
Windows FILETIME / LDAP
WebKit / Chrome
.NET ticks
Apple Cocoa Core Data
Mac HFS+
NTP
SAS
GPS
Excel / Google Sheets
Julian Day (JD)
Modified Julian Day (MJD)
Unix in hexadecimal

Each scale is just a pair of start date + unit: FILETIME counts 100 ns slices since 1601, Excel counts days since 1899, Cocoa counts seconds since 2001. Two caveats: GPS time ignores leap seconds and has therefore run 18 s ahead of UTC since 2017, and Excel’s start date is 30/12/1899 because the spreadsheet believes 1900 is a leap year.

Start and end of a period

Timestamp Date and time
Start
End

The end is the last second of the period, not the first of the next one: 23:59:59 rather than 00:00:00 the following day. It is computed on the calendar rather than by rounding a timestamp — a month is not a fixed number of seconds, and a day with a clock change is not 86,400 s long. The week starts on Monday.

Seconds to a duration

Years
Months
Days
Hours
Minutes
Seconds

The year and the month are averages, and cannot be anything else: a bare duration is attached to no date, hence to no February and no leap year. Mean Gregorian year 365.2425 days, month = one twelfth of it.

A duration to seconds

Total in seconds

Empty fields count as zero, and negative numbers are accepted — 2 months −3 days computes. The year and the month are the same averages as opposite.