Mysql select date value preformatted? 1

[thedaver]

MySQL stores "datetime" fields as YYYY-MM-DD HH:MM:SS format.
Is there a PHP 4.3.10 method to select from MySQL 3.x to obtain the date in a preformatted manner?

I'd like to be able to retrieve the date from the db as
MM-DD-YYYY

If not easy from DB, does someone have a code snippet to do the work?

Help appreciated.

Hosting Solutions for Home or Business.

http://www.surfinbox.com/hosting/

 

[Olavxxx]

Hi,
I could just give you the mysql function, but I think you should read here:

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

As that would be more informative to you.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[thedaver]

Ah, date_format, a beautiful thing. Dummy me, I was expecting PHP to provide such a tool. Thanks DaButcher!

Hosting Solutions for Home or Business.

http://www.surfinbox.com/hosting/

 

[Olavxxx]

You should always do as much as possible inside the db, as that is much faster!

Thank you for the star, and good luck on your project.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster