• Hi..Try this

    select cast(datediff(yyyy, '2006-01-01', '2008-01-01') as varchar) + 'Y : '

    + cast(datediff(mm, '2006-01-01', '2008-01-01') as varchar) + 'M : '

    + cast(datediff(dd, '2006-01-01', '2008-01-01') as varchar) + 'D'