Changing Date Format (on the fly)

[Anon]

Hello.

I have a date (stored in MySQL) that is coming out (stored) in the format of:

Y-m-d h:i:s

I would like to be able to display it at:

Y-m-d g:i A

I need it stored in the value that it is presently being stored in (for other parts of the script), however, in one particular place, I need the date to be formated (displayed) in: Y-m-d g:i A

Is there any easy to to do this?

Thanks.
JbA

[Anon]

Check out the date(); function in php and DATE_FORMAT( col, sFormat ); in mysql.

[Anon]

Been there done that, Ronnie.

I know I could do it with mktime, but I would prefer not to.

And, I can't use MYSQL... because I am already doing a time change with the SELECT function... I need a snippit of PHP code to make this change!