Quote:
Originally Posted by BradM
Keith I think that would work, only problem is I am getting a syntax error and this is too advanced for me to troubleshoot:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM -7 FOR 2))' at line 1
|
hey there
he wrote that he wasn't fully awake ;)
there is some garbage in the sql, (FROM and FOR).. the sql should read:
UPDATE b1datefix SET date2 = CONCAT(SUBSTRING(date,-4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date, -7,2));
let us know how it goes ;)
peace