Hi, I’m trying to convert an existing field in a MySQL table, of type varchar, to date
I’m enclosing the following in a cfquery but it’s throwing an error ‘Incorrect datetime value: ‘Adult’ for function str_to_date’
UPDATE pupils
SET new_birthdate = STR_TO_DATE(birthdate,'%d/%m/%Y');
Is there a better / alternative way to do this?