Displaying Date from database PHP

Question

right now I'm storing a date in the database, in the format date("Y-m-d") and im storing it in date column.

Now, I've retrieved it from the database but how can i display it like

October 31st 2010

Thanks!

deceze · Accepted Answer · 2010-11-01 02:05:51Z

5

Convert the date to a timestamp using strtotime and format it using date.

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

The preferred way going forward should be the use of the DateTime class though:

date_default_timezone_set('Asia/Tokyo');

$date = new DateTime($databaseDate);
echo $date->format('F jS Y');

answered Nov 1, 2010 at 1:49

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

2 Comments

Although this works perfectly, you might want to learn how to use the DateTime class of PHP php.net/manual/en/class.datetime.php.

@Itay Fair enough, added for completeness.

hakre · Accepted Answer · 2012-11-04 17:22:39Z

3

Use date_format in your SQL query.

Example: date_format(somefield, '%d-%m-%Y, %h:%i %p')

hakre

200k55 gold badges454 silver badges865 bronze badges

answered Nov 1, 2010 at 1:53

zerodin

8775 silver badges10 bronze badges