I have a varchar column with max length of 14
Characters I’m trying to convert it to date time
Using select convert(date time, stuff(stuff(stuff(updated,13,0,’:’). ,12,0,’:’),9,0,’ ‘)) from emp.
This works on other columns with the same length of 14 but on the updated column it errors out saying date time data type resulted in out of range value