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!
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!
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');