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
mysql question
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: mysql question
Have a look at the DAE_FORMAT() mysql function.