[SOLVED] format date

[AdRock]

This is probably an easy one but i've never had to use it before until now and it's doing my head in

 

I have a date field in my database and need to order by date so formatting the date in the SQL is not an option

 

I want to format the date so it looks like 14th March 2009 or something similar.

 

I tried using strtotime and strftime which works but I am struggling with the day.  How can I get the day number and is there st, nd, th etc to follow the day?

 

<?php

echo strftime("%e %B %Y", strtotime("2009-03-16 11:33:54"));

?>

[kenrbnsn]

Use date

<?php
echo date('jS F Y', strtotime("2009-03-16 11:33:54"));
?>

 

Ken

[AdRock]

Thanks...i'll rememebr that in future