Page 1 of 1

mysql question

Posted: Thu Apr 10, 2008 11:06 am
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

Re: mysql question

Posted: Thu Apr 10, 2008 3:28 pm
by RobertGonzalez
Have a look at the DAE_FORMAT() mysql function.