By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select datefromparts(right(str, 4), left(str, 2), substring(str, 3, 2)),
convert(date, left(right(str, 4) + str, 8))
from (values ('02121955')) v(str)
| (No column name) | (No column name) |
|---|---|
| 1955-02-12 | 1955-02-12 |