mySQL convert varchar to date

Question

I need to convert a varchar value of 1 9 2011 to a date in mySQL and I want only the month and year   So that I can then use the PERIOD DIFF function  so I would need the above to be converted to 201101    I ve tried various ways using the STR TO DATE function   SELECT STR TO DATE CYOApp oilChangedDate    m  Y   FROM CYO AppInfo   But I get weird results     for example  2009-01-00   What am I doing incorrectly

User · Accepted Answer

select date format str to date  31 12 2010     d  m  Y      Y m       or  select date format str to date  12 31 2011     m  d  Y      Y m       hard to tell from your example

User · Answer

As gratitude to the timely help I got from here - a minor update to above    query    UPDATE  db   table  SET  fieldname    str to date   fieldname    d  m  Y

[mysql] mySQL convert varchar to date

Examples related to mysql