select DATEADD(day,convert(int,substring(‘117064’,4,3))-1,
convert(date,‘20’+substring(‘117064’,2,2)+’-01-01’))
12-19
654
select DATEADD(day,convert(int,substring(‘117064’,4,3))-1,
convert(date,‘20’+substring(‘117064’,2,2)+’-01-01’))