[RESOLVED] Converting YYYY-MM-DD to a string date format

[include_me]

Hi,

I have a date field in my DB with the date stored like YYYY-MM-DD and was wondering when getting this out of the DB and displaying it on a page if there was any way of geting to appear as: "Wednesday 26th December 2007"?

If so how do I go about converting this?

Thanks,
Chris

[NogDog]

Use [man]strtotime/man to convert it to a "UNIX time" integer, then use [man]date/man to convert that to the desired output format.

PS: Possibly a better alternative would be to convert it within the query itself. For instance, if using MySQL, you could do that via the DATE_FORMAT() function.

[include_me]

Thanks NogDog! thats brill worked!