with t as (select 123 as id, 2 as y , 15 as m, 63 as d )
   , x as ( select id, dateadd(day, d, dateadd( month, m, dateadd( year, y, 0 ) ) ) as dt from t )
   select id
        , datediff( year, 0, dt ) as y
        , datediff( month
                  , dateadd( year, datediff( year, 0, dt ), 0)
                  , dt 
                  ) as m
        , datediff( day 
                  , dateadd( month
                            , datediff( month
                                      , dateadd( year, datediff( year, 0, dt ), 0)
                                      , dt 
                                      )
                            , dateadd( year, datediff( year, 0, dt ), 0)
                            )
                  , dt 
                  ) as d
     from x;