I have a database field Column_A which is in Varchar(16) not null and the values are for example 20191210215033CS but I want to break it like 2019-12-10 21:50:33
Since it is a production database there is no way to change the data type.
Tried the below code
SELECT convert(datetime, 'Column_A', 120) but getting the error
Conversion failed when converting date and/or time from character string.
Is their any workaround ? Any help will be greatly appreciated !