Written by 
In MySQL 5.6, I have a varchar column that has a datetime that looks like this: `2024-09-03 02:00:07` I can run this query: select date_format(str_to_date(`column1`, ‘%Y-%m-%d %H:%i:%s’), ‘%m/%d/%Y’) from table; This returns the column1 dates in a format that looks like this: 09/03/2024 However when I run this update query: update table set `column1` = […]
