date formatting?

[Luz]

hi all,
I loaded the *.txt file to the MYSQL DB. but, there is on field column carrying the date format in dd/MM/yyyy. How could I suppose to change the date format to the default MYSQL date format?
Thanks! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

MySQL only likes dates in YYYY-MM-DD format (or YY-MM-DD). There is no feature to change this.

Your can pre-filter the .txt file before loading it to MySQL, or else load it into a VARCHAR field and then copy that data to a DATE field using STR_TO_DATE() to convert the values to the format MySQL wants. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --