ColumnA is BIGINT, contains values like this: 20040927, 19990729, 19990722
ColumnB is DATE, it is NULL.
The table is loaded from a csv, I just need to update columnB from columnA, after the file is loaded.
I'm just trying a basic CAST in the update, and I am receiving the error in my title line.
SET ColumnB = CAST(ColumnA AS DATE)