• DECLARE @d varchar(6) = '20114'

    SELECT try_convert(date, substring(@d, 1, 4) +

    CASE WHEN len(@d) = 5 THEN '0' ELSE '' END +

    substring(@d, 5, 2) + '01')

    This worked but I am not getting in 101 style that is 04/01/2011