Format MySQL DATETIME Values in PHP with DateTime

You will learn how to parse the standard MySQL DATETIME string in PHP and display it in a user-friendly 12-hour date and time format. You will also learn the important difference between PHP format characters such as m, i, h, and H.

A MySQL DATETIME value is normally returned to PHP as a string in this format:

YYYY-MM-DD HH:MM:SS

For example:

2025-03-08 14:05:00

The database format is designed for reliable storage and sorting, not necessarily for display to users. PHP's DateTimeImmutable class lets you:

1. Parse the database string into a date/time object.
2. Format that object using a display pattern.

For a display like 03/08/25 02:05 PM, use this PHP format string:

'm/d/y h:i A'

The letters are case-sensitive. In particular, PHP uses i for minutes. m means month, so using H:M does not mean hours and minutes in PHP.

Think of a date/time as an appointment written in one universal office format: 2025-03-08 14:05:00. That is useful for filing and sorting, so it is how the database stores it.

DateTimeImmutable is a translator. You give it the office format, then ask it to print the same appointment in a format your visitor expects, such as 03/08/25 02:05 PM.

The format string is the translator's instruction sheet:

• m says “print the month.”
• d says “print the day.”
• y says “print the two-digit year.”
• h says “print the hour on a 12-hour clock.”
• i says “print the minutes.”
• A says “print AM or PM.”

Parse a MySQL DATETIME value explicitly, then call format().

<?php
$mysqlDateTime = '2025-03-08 14:05:00';

$date = DateTimeImmutable::createFromFormat(
    'Y-m-d H:i:s',
    $mysqlDateTime
);

if ($date === false) {
    throw new RuntimeException('The date from the database is invalid.');
}

$displayDate = $date->format('m/d/y h:i A');

echo $displayDate; // 03/08/25 02:05 PM

The parsing pattern, Y-m-d H:i:s, matches the usual MySQL DATETIME value:

Consider this code:

<?php
$mysqlDateTime = '2025-03-08 14:05:00';
$date = DateTimeImmutable::createFromFormat('Y-m-d H:i:s', $mysqlDateTime);

echo $date->format('m/d/y h:i A');

Step by step:

1. $mysqlDateTime contains the string retrieved from MySQL: 2025-03-08 14:05:00.
2. createFromFormat('Y-m-d H:i:s', ...) reads the string as:
   • year 2025
   • month 03
   • day 08
   • 24-hour time 14:05:00
3. PHP creates a DateTimeImmutable object representing that moment.
4. format('m/d/y h:i A') prints:
   • m → 03

Formatting database timestamps is common whenever technical storage values must be shown to people:

• Order history: Display an order time such as 03/08/25 02:05 PM.
• Admin dashboards: Show when an account was created or a record was updated.
• Booking systems: Present appointment times in a familiar local format.
• Activity feeds: Display when a comment, upload, or status change occurred.
• Email notifications: Include readable event dates rather than raw database strings.

The storage format can remain consistent in MySQL while each part of the application chooses an appropriate display format.

In real PHP applications, date formatting is usually kept near the presentation layer: a template, API resource, view model, or serializer. The database continues to store a standard value, while the application formats it only when returning it to a user.

A reusable helper can centralize the display rule:

<?php
function formatDatabaseDateTime(?string $value): ?string
{
    if ($value === null) {
        return null;
    }

    $date = DateTimeImmutable::createFromFormat('!Y-m-d H:i:s', $value);
    $errors = DateTimeImmutable::getLastErrors();

    if ($date === false || ($errors !== false && ($errors['warning_count'] > 0 || $errors['error_count'] > 0))) {
        throw new InvalidArgumentException('Expected a MySQL DATETIME value.');
    }

    return ->();
}

Using M for minutes

In PHP, uppercase M is a short month name, not minutes.

// Incorrect: M means Jan, Feb, Mar, and so on.
echo $date->format('m/d/y H:M');

Use lowercase i for minutes:

echo $date->format('m/d/y h:i A');

Using H while also displaying AM/PM

H is a 24-hour hour (00 through 23). It does not fit a 12-hour display with AM or PM.

// Confusing output: 14:05 PM
echo $date->format('m/d/y H:i A');

Use for a zero-padded 12-hour hour:

// Standard MySQL DATETIME input
$mysqlDateTime = '2025-03-08 14:05:00';

// Parse it
$date = DateTimeImmutable::createFromFormat('Y-m-d H:i:s', $mysqlDateTime);

// Display: 03/08/25 02:05 PM
echo $date->format('m/d/y h:i A');

How do I format a MySQL DATETIME in PHP?

Parse the value with DateTimeImmutable::createFromFormat('Y-m-d H:i:s', $value) and call format('m/d/y h:i A').

What PHP format character represents minutes?

Use lowercase i. For example, h:i A produces 02:05 PM.

Why does PHP use i instead of m for minutes?

PHP reserves m for the numeric month. Its date-format characters are historical and case-sensitive, so minutes use i.

Should I use H or h with AM/PM in PHP?

Use h for a 12-hour clock with a leading zero, or g without one. Use H only for a 24-hour clock and do not add AM/PM.

Can I format a NULL DATETIME value?

Yes, but check for null before parsing. A missing date should usually remain or be displayed as a placeholder such as .

• PHP DateTimeImmutable — The object used to safely represent, parse, and format dates without changing the original object.
• PHP date format characters — The reference for choosing tokens such as Y, m, d, H, and i.
• MySQL DATETIME vs TIMESTAMP — Both store date-related values, but they have different time-zone behavior and ranges.
• Time zones in PHP — Important when stored dates represent UTC or when users are in different locations.
• Input validation in PHP — Useful for checking that incoming date strings match the format your code expects.
• International date formats — Helps when an application must display dates differently for different regions.