Modified Julian Date to date and time (ISO 8601, UTC)
Type a value in MJD to get it in UTC instantly.
2009-02-14 00:00:00UTC
That moment falls on a Saturday, day 45 of 2009 (UTC).
What it means
Where is that on the timeline?
All dates are UTC. Unix time and these counts ignore leap seconds; Excel serials follow the 1900 date system and start at 1 March 1900.
The math
How to convert MJD to UTC
date = 1970-01-01 00:00:00 UTC + timestamp seconds. Excel serial = Unix ÷ 86,400 + 25,569; Julian Date = Unix ÷ 86,400 + 2,440,587.5.
Example: 54876 MJD = 2009-02-14 00:00:00 UTC.
Every unit
That moment in every format
Tables
MJD to UTC conversion table
| MJD | UTC |
|---|---|
| 51544 MJD | 2000-01-01 00:00:00 UTC |
| 52161 MJD | 2001-09-09 00:00:00 UTC |
| 53318 MJD | 2004-11-09 00:00:00 UTC |
| 54476 MJD | 2008-01-11 00:00:00 UTC |
| 55633 MJD | 2011-03-13 00:00:00 UTC |
| 56791 MJD | 2014-05-14 00:00:00 UTC |
| 57948 MJD | 2017-07-14 00:00:00 UTC |
| 59106 MJD | 2020-09-14 00:00:00 UTC |
| 60263 MJD | 2023-11-15 00:00:00 UTC |
| 61420 MJD | 2027-01-15 00:00:00 UTC |
| 62578 MJD | 2030-03-18 00:00:00 UTC |
| 63735 MJD | 2033-05-18 00:00:00 UTC |
| 65442 MJD | 2038-01-19 00:00:00 UTC |
UTC to MJD conversion table
| UTC | MJD |
|---|---|
| 2000-01-01 00:00:00 UTC | 51544 MJD |
| 2001-09-09 01:46:40 UTC | 52161.074074 MJD |
| 2004-11-09 11:33:20 UTC | 53318.481481 MJD |
| 2008-01-10 21:20:00 UTC | 54475.888889 MJD |
| 2011-03-13 07:06:40 UTC | 55633.296296 MJD |
| 2014-05-13 16:53:20 UTC | 56790.703704 MJD |
| 2017-07-14 02:40:00 UTC | 57948.111111 MJD |
| 2020-09-13 12:26:40 UTC | 59105.518519 MJD |
| 2023-11-14 22:13:20 UTC | 60262.925926 MJD |
| 2027-01-15 08:00:00 UTC | 61420.333333 MJD |
| 2030-03-17 17:46:40 UTC | 62577.740741 MJD |
| 2033-05-18 03:33:20 UTC | 63735.148148 MJD |
| 2038-01-19 03:14:07 UTC | 65442.134803 MJD |
Quick answers
Quick answers
- How many UTC is 1 MJD?
- 1 MJD is 1858-11-18 00:00:00 UTC.
- How many UTC is 10 MJD?
- 10 MJD is 1858-11-27 00:00:00 UTC.
- How many UTC is 54876 MJD?
- 54876 MJD is 2009-02-14 00:00:00 UTC.
The units
About these units
Modified Julian Date (MJD)
Julian Date minus 2,400,000.5: days since 17 November 1858.
Date and time (ISO 8601, UTC) (UTC)
The date written as year-month-day and time, in UTC.
Keep going