Convert datetime to Y-m-d H:i:s format

Question

I have a datetime field which saves the date in numerical format:

2013-11-23 21:21:31

I want to format this value into Y-m-d H:i:s so that instead of a list of numbers it reads as:

23rd November 2013

with or without the time, doesn't really matter too much.

Is this possible using date() or is that just for submitting data?

score 1 · Accepted Answer · answered Nov 23 '13 at 18:03

1

Convert the date string to a timestamp using strtotime() and feed it to date():

echo date('jS F Y', strtotime($dateStringFromDB));

For other available formatting options, refer to the documentation for date().

answered Nov 23 '13 at 18:03

Amal Murali

This won't work because I'm not actually using `2013-11-23 21:21:31`, I'm getting dates using a variable. – Dalían Nov 23 '13 at 18:06
@SethForza: Sure, it would. You can substitute the string with a variable. See the updated answer. – Amal Murali Nov 23 '13 at 18:07
Thanks, it worked after I set the variable. – Dalían Nov 23 '13 at 18:12

1 Answers1