By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Select convert(datetime,format(convert(bigint,
left('20191210215033CS',14)),'####/##/## ##:##:##'))
| (No column name) |
|---|
| 2019-12-10 21:50:33.000 |
| (No column name) |
|---|
| 2019-12-10 21:50:33.000 |