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
|
Aha I knew I'd have a typo
- Damn comma.
Try this:
UPDATE b1datefix SET date2 = CONCAT(SUBSTRING(date,-4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date FROM -7 FOR 2));