Thread: date formatting?
View Single Post
  #2  
Old 08-09-2006, 08:09 AM
sierra sierra is offline
Senior Member
  
Join Date: Jul 2006
Posts: 220
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
sierra is on a distinguished road
Default
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 --
Reply With Quote
  Webmaster Forums - View Single Post - date formatting?
Thread: date formatting?
View Single Post
  #2  
Old 08-09-2006, 08:09 AM
sierra sierra is offline
Senior Member
  
Join Date: Jul 2006
Posts: 220
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
sierra is on a distinguished road
Default
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 --
Reply With Quote