PHP DateTime Format

Question

How would you change the format of the DATETIME from a MySQL Database.

Code:

echo $r["date"]; echo date("F j, g:ia",$r["date"]);

Output:

2014-02-05 15:31:51 December 31, 6:33pm

These are both two different dates, not sure why.

Look at the documentation for date (php.net/date)... It's second parameter is a unix timestamp, not a string. — Jasper
– Jasper, Commented Feb 5, 2014 at 21:39

Community · Accepted Answer · 2023-11-17 20:33:26Z

date() requires the second parameter to be a unix timestamp. You need to pass your datetime string to strtotime() before using it in date()

echo date("F j, g:ia",strtotime($r["date"]));

Robbert · Accepted Answer · 2014-02-05 21:39:38Z

Use strtotime

echo date("F j, g:ia",strtotime($r["date"]));

The second parameter for the date function requires a timestamp. strtotime converts a date string to a timestamp.

Lajos Veres · Accepted Answer · 2014-02-05 21:39:46Z

Try this way:

echo date("F j, g:ia",strtotime($r["date"]));

Mysql returns a string, not a unix timestamp. You should convert it before using with date().

3 Answers 3