Home Forums SQL Server 2008 SQL Server 2008 - General how to get date difference in years month and date RE: how to get date difference in years month and date
VSSGeorge
SSCrazy Eights
Points: 8146
More actions
January 5, 2011 at 2:12 am
#1269348
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'