PHP Date and Time Formatting Like MySQL NOW()

By the end of this page, you will understand how to create a MySQL NOW()-style datetime string in PHP, why PHP does not have a special NOW() equivalent for this exact output, and how to use date() correctly to produce YYYY-MM-DD HH:MM:SS values.

PHP does not provide a special built-in function whose only purpose is to return the current datetime in MySQL NOW() string format.

Instead, PHP uses a general date formatting approach. The most common way to generate a string like MySQL NOW() is:

date('Y-m-d H:i:s')

This works because PHP's date() function lets you build date/time strings using formatting characters:

• Y = 4-digit year
• m = 2-digit month
• d = 2-digit day
• H = 2-digit hour in 24-hour format
• i = 2-digit minutes
• s = 2-digit seconds

So this format string:

'Y-m-d H:i:s'

produces output like:

2026-06-10 14:30:

Think of PHP's date() as a date stamp machine.

• The machine always knows the current time.
• You choose the template for how the stamp should look.
• Y-m-d H:i:s is just one template.

MySQL NOW() is like asking the database server to stamp the current datetime. PHP date('Y-m-d H:i:s') is like asking the PHP application to stamp it.

Both can print something that looks identical, but the stamp comes from a different clock.

The core syntax is:

date('Y-m-d H:i:s')

Basic example

<?php
echo date('Y-m-d H:i:s');

Possible output:

2026-06-10 14:30:05

Store it in a variable

<?php
$now = date('Y-m-d H:i:s');
echo $now;

Use with a specific timestamp

<?php
echo date('Y-m-d H:i:s', 1262304000);

Output:

2010-01- ::

Consider this code:

<?php
$now = date('Y-m-d H:i:s');
echo $now;

Step by step:

1. PHP calls date('Y-m-d H:i:s').
2. PHP reads the current server time.
3. It formats that time using the pattern:
   • Y → year
   • m → month
   • d → day
   • H → hour
   • i → minute
   • s → second
4. PHP returns a string such as:

   2026-06-10 14:30:05
   

5. That string is stored in $now.
6. echo $now; prints the result.

Traceable example

This format is common in many real programs.

Database inserts

<?php
$createdAt = date('Y-m-d H:i:s');

You might store this in a created_at column.

Application logging

<?php
$logLine = '[' . date('Y-m-d H:i:s') . '] User logged in';

API payloads

Some systems expect a MySQL-style datetime string:

<?php
$data = [
    'processed_at' => date('Y-m-d H:i:s')
];

File generation or exports

<?php
$filenameTime = date('Y-m-d_H-i-s');

A slightly modified version is often used in filenames because colons are inconvenient in file names on some systems.

In real projects, developers often choose between generating the datetime in PHP or letting the database do it.

Common patterns

• Application-side timestamp: use PHP when the app decides the time value.
• Database-side timestamp: use MySQL NOW() or column defaults when the database should control timestamps.
• Consistency: pick one source of truth when possible.

Example: validation before saving

<?php
$name = trim($_POST['name'] ?? '');

if ($name === '') {
    exit('Name is required');
}

$createdAt = date('Y-m-d H:i:s');

This uses a guard clause and creates the timestamp only after validation succeeds.

Example: with DateTime for better control

<?php
$dt = new DateTime('now', new DateTimeZone('UTC'));
 = ->();

1. Assuming PHP has a dedicated NOW() function

Broken expectation:

<?php
echo now();

This is not a built-in PHP function.

Use:

<?php
echo date('Y-m-d H:i:s');

2. Using the wrong format characters

Broken code:

<?php
echo date('Y-M-D H:m:s');

Why it is wrong:

• M is short textual month, not numeric month
• D is short textual day name, not day of month
• m is month, not minutes

Correct code:

<?php
echo date('Y-m-d H:i:s');

3. Forgetting about time zones

date() vs DateTime

// MySQL NOW()-style output in PHP
date('Y-m-d H:i:s');

Format pieces

• Y = 4-digit year
• m = 2-digit month
• d = 2-digit day
• H = 24-hour hour
• i = minutes
• s = seconds

Common example

<?php
echo date('Y-m-d H:i:s');

Modern equivalent

<?php
echo (new DateTime())->format('Y-m-d H:i:s');

Time zone-safe version

<?php
$dt = new DateTime(,  ());
 ->();

Is there a PHP equivalent of MySQL NOW()?

Not as a dedicated built-in function with that exact purpose. In PHP, the usual solution is date('Y-m-d H:i:s').

What is the correct PHP format for 2009-12-01 00:00:00?

Use:

date('Y-m-d H:i:s')

Why is i used for minutes instead of m in PHP?

Because m already means month in PHP date formatting. Minutes use i.

Should I use PHP date() or MySQL NOW()?

Use PHP if your application should decide the timestamp. Use MySQL if the database should generate it. Be consistent about time zones.

Does date('Y-m-d H:i:s') return a string or a date object?

It returns a string.

Is DateTime better than date()?

For simple formatting, both are fine. For time zones, intervals, parsing, and more complex operations, is usually better.

• date() — The main PHP function for formatting dates and times.
• DateTime — A more flexible object-oriented way to work with dates in PHP.
• DateTimeZone — Important for controlling time zone behavior.
• strtotime() — Useful for converting date strings into timestamps.
• Unix timestamp — Helps explain how PHP represents time internally.
• MySQL NOW() — Closely related because it generates the current datetime on the database side.
• UTC time — Important for storing consistent timestamps across systems.