Skip to content

MM/DD/YYYY to YYYY-MM-DD 12h converter

US date (MM/DD/YYYY) → Year-first date with 12-hour time

YYYY-MM-DD 12h · YYYY-MM-DD h:mm:ss A

2024-06-09 12:00:00 AM

No time of day in the value: read as the start of the day (00:00), UTC.

How should 06/09/2024 be read?Time of day:
Why a time of day?

9 June 2024 names a day, not a moment: no time of day was given, so there is no single instant for it in UTC. Choose the time of day to assume, or keep the date as written.

Worked examples

InstantMM/DD/YYYYYYYY-MM-DD 12h
an ordinary day06/29/20262026-06-29 12:00:00 AM
a leap day02/29/20282028-02-29 12:00:00 AM
the Unix epoch01/01/19701970-01-01 12:00:00 AM

A date has no time of day. These examples, like the tool, read it as the start of the day (00:00) in UTC; the tool offers noon or keeping the date as written.

What this conversion changes

  • A date has no time of day: before writing a time or a timestamp, the tool asks which time to assume (the start of the day or noon, in UTC). Nothing is filled in silently.
  • The 24-hour clock becomes a 12-hour clock with AM/PM; nothing is lost.

MM/DD/YYYY — US date (MM/DD/YYYY)

Pattern
MM/DD/YYYY
Example
06/09/2024
Seen in
US business documents, Excel (US locale), Exports from US SaaS tools

YYYY-MM-DD 12h — Year-first date with 12-hour time

Pattern
YYYY-MM-DD h:mm:ss A
Example
2024-06-29 2:30:00 PM
Seen in
Spreadsheets with mixed locale settings

Thousands of values to convert?

CSV batch mode converts an entire column from MM/DD/YYYY to YYYY-MM-DD 12h (or any of the 82 formats, with time-zone shifts), entirely in your browser, with no row limit set by us (your device's memory is the practical ceiling). $9.99/month, hides the ads, cancel anytime.