PHP Date format?

[PowerStrike]

When you storing DATE in MySQL, the default DATE datatype format is YYYY-MM-DD

For example: 2006-05-20

How to convert this to '20 May 2006' in PHP?

[supremewebdesign]

// where $date is the date you wish to convert

// first convert to a timestamp
list($year, $month, $day) = explode('-', $date);

$timestamp = mktime(0, 0, 0, $month, $day, $year);

// then convert to a date
$converted = date('j F Y', $timestamp); 

http://uk2.php.net/manual/en/function.explode.php - php explode function
http://www.php.net/manual/en/function.mktime.php - php mktime function
http://www.php.net/manual/en/function.date.php - php date function

Hope this helps!

[JREAM]

You can also do it right when it comes out of MySQL using date_format:

SELECT 
    date_format(field_name, '%d %M %Y'), 
    other_field_name,
    maybe_another_field
FROM 
    table_name

[mmarif4u]

echo date('d M Y'); 

For mysql:

$date = $row->date;
echo date('d M Y',strtotime($date)); 

[eLIANT]

Check here: us2.php.net/manual/en/function.strtotime.php
(there are many date/time related functions in PHP - you should surf around at php.net)

Or, if you intend to do math or otherwise manipulate the m/d/y pieces of the date, try this:
list($y, $m, $d) = explode($StoredDate, "-");

[sorry for duplicating the answers of others - I type too slow, I guess.]

[felgall]

To decide where to do the conversion to the date format you want.

If it is a really simple application where you are extracting the date and displaying it straight away then use the SQL command to return the date in the format you are going to display it in.

If the application is more involved then process the date throughout in the ccyy-mm-dd format that it gets returned in and have convert it to the desired display format when processing the template file to output the page.

[gentleRain]

There's a huge detailed list in PHP.net, check that list. You can provide any date format with true codes.