By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select convert(date,
right(format(processdate, '00000000'), 4) + substring(format(processdate, '00000000'), 3, 2) +left(format(processdate, '00000000'), 2)
)
from (values (11082021), (1082021)) v(processdate)
| (No column name) |
|---|
| 2021-08-11 |
| 2021-08-01 |
select convert(date, right(v.processdate_str, 4) + substring(v.processdate_str, 3, 2) + left(v.processdate_str, 2))
from (values (11082021), (1082021)) i(processdate) cross apply
(values (format(i.processdate, '00000000')
) v(processdate_str)
Msg 102 Level 15 State 1 Line 4
Incorrect syntax near 'v'.