date format

[varsha]

hi all,
i have date stored in database in yyyy-mm-dd format..
bt while displaying on page i wanna display in d-m-yyyy fomat...
how do i do tht?
like eg.....
event_date=2007/01/20-------saved in database..
bt i want to display like 20th Jan 2007....
similiarly for time...in database it is saved as 02:30:00....
bt i want to display it as 02:30 AM....

hw do i do this?

its urgent

regrds
varsha

[Weedpacket]

Your database system should have functions for formatting dates and times. Ideally, use them. Failing that, use [man]strtotime[/man] to convert it into a timestamp and [man]date[/man] to format it.

[rincewind456]

The easiest way would be by using the DATE_FORMAT() function in Mysql, which I presume your using.

Or you could look at the [man]date/man function in the PHP manual.