PHP Date Format

[centenial]

Hi,

I have a database table with several hundred records. The DB table has these fields:
- id
- name
- date

All the dates are in YYYY-MM-DD format. However, when they're displayed on my website, I want the dates to display like this:

Jan 1, 2006 or
Dec 12, 2006 (whatever the correct date is)

Is there a function in PHP that I can use to convert YYYY-MM-DD to the more elegant format above?

Thanks for your help,

[NogDog]

It's probably more efficient to do it in the SQL:

$query = "SELECT `co1`, `col2`, DATE_FORMAT(`date_col`, '%b %e, %Y') as `date_formatted` FROM `table_name`";
$result = mysql_query($query) or die (mysql_error());
$row = mysql_fetch_assoc($result);
echo "The date is: " . $row['date_formatted'];

[phpjaco]

look up either the date function in php or you can probably use DATE_FORMAT in mysql.

[Oni]

I would simply use the explode function then make a small array for how you want to write the months...
http://tr2.php.net/manual/en/function.explode.php