Formatting MySQL timestamp to PHP DateTime

Question

How can I format a timestamp from MySQL to a date value in PHP?

(hint) How a date is formatted has nothing to do with how it is represented internally or how it is stored. — Gordon
– Gordon, Commented Jun 3, 2011 at 14:30
If mysql formatting isn't enough for you, then you can use SELECT UNIX_TIMESTAMP(datecolumn) ... to get a unix timestamp for use in php's date() function. Would be a lot more optimal than parsing it with strtotime that they used in the answers below. — jishi
– jishi, Commented Jun 3, 2011 at 14:41
Thank you for the suggestion. That's probably the way to go. You could add this to the answers if you'd like me to accept it. — Chalise
– Chalise, Commented Jun 3, 2011 at 14:44

Ry- · Accepted Answer · 2012-01-27 14:38:46Z

3

Formatting and storing of a date can be perfectly seperated. Use strotime and strftime to calculate timestamps and use those with date.

In your view:

date('F d, Y at g a', strtotime($storedDate));

Wherever you store your date

date('Y-m-d H:i:s', strtotime($formattedData));

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

answered Jun 3, 2011 at 14:35

vindia

1,66810 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jason McCreary · Accepted Answer · 2011-06-03 14:34:11Z

0

echo date('r', strtotime($mysql_datetime_column_value));

See the date() function in the PHP documentation for more detail.

answered Jun 3, 2011 at 14:34

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges