mysql question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
renny
Forum Newbie
Posts: 1
Joined: Thu Apr 10, 2008 11:00 am

mysql question

Post by renny »

Hello,

I have an app that does a load data infile into a mysql table but one of the columns in the file is formatted mm/dd/yyyy (04/04/2008) and i would like it to be in the standard yyyy-mm-dd (2008-04-04) format. There are thousands of records and what is the most efficient way of changing the format?

Thank you so much!

-R
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Re: mysql question

Post by RobertGonzalez »

Have a look at the DAE_FORMAT() mysql function.
Post Reply