mysql date to normal date?

[turpentyne]

Does anybody know how to take the queried standard date format - 2012-04-02 for example - and print it to the page as April 2, 2012? Or at the very least, to switch to 04-02-2012? Trying to find some tutorials online.

 

 

[timmah1]

http://php.net/manual/en/function.date.php

[timmah1]

$date = date('F j, Y');

echo $date;

[turpentyne]

hmmm... not today's date?

 

I'm trying to convert $table_row['workshop_date'] which is 2012-12-02 into a date.

 

I'll have to look through that first link, and see if I can understand

 

[PFMaBiSmAd]

Use the mysql DATE_FORMAT() function in your query to format your date (or datetime or time) column any way you want when you select it - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[timmah1]

I always use this when pulling the date from the db

$date = date('F j, Y', strtotime($table_row['workshop_date']));

[Pikachu2000]

Use the mysql DATE_FORMAT() function in your query to format your date (or datetime or time) column any way you want when you select it - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

 

+1