twiog
-
Posts
3 -
Joined
-
Last visited
twiog's Achievements
Newbie (1/5)
0
Reputation
-
OMGosh that did it!!! Thanks so much.
-
I imported the data from a CSV file which had the date field in that format. Once I update all of the dates to proper dates in the CreateDate field I will delete the CreateDateTxt field.
-
I'm using MySQL 5.5 I have a varchar 25 field called CreateDateTxt which is full of dates like this 3/15/2014 I have a date field called CreateDate which I would like to populate based on the CreateDateTxt field I can populate the CreateDate field successfully using this: UPDATE tblMembers SET CreateDate = '1975-12-07' But it doesn't give me the results I want using this: UPDATE tblMembers SET CreateDate = str_to_date(CreateDateTxt,'%d %m %Y') The query runs without errors but It populates the CreateDate field in all the records with this: 0000-00-00 Any help? Thanks!