Convert date format

[dreamwest]

How can i convert a number date format to a name based one. All dates are stored as digets in my database:

 

10-05-2009

 

and im using a date format to display them in tempates:

 

{$user_details.adddate|date_format:"%d- %m -%Y"}

 

I just need to convert the month to a name, but because the date is stored as a number %F wont work

[thebadbad]

Are you sure they are stored in the dd-mm-yyyy format? yyyy-mm-dd is the MySQL (and international) standard. But to get the full textual representation of the month, you can use:

 

<?php
$date = '10-05-2009';
list($d, $m, $y) = explode('-', $date);
echo date('F', mktime(0, 0, 0, (int) $m)) . " $d $y";
?>

And if you use the standard format:

 

<?php
$date = '2009-05-10';
echo date('F j Y', strtotime($date));
?>

[dreamwest]

Yes work well. Thanks