Database

Eddy Vluggen wrote:

What does your question have to do with databases?

maxRazar wrote:

difference between date1 and date2 should show as "1 year, 2 months and 2 days"

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Mycroft Holmes wrote:

do the datediff 3 times getting the Y/M/D separately and concatenate them as you want.

declare @start date = '20121231';
declare @end date = '20130101';
select
   cast(datediff(year, @start, @end) as varchar(5)) + ' year, '
   + cast(datediff(month, @start, @end) as varchar(5)) + ' month, '
   + cast(datediff(day, @start, @end) as varchar(5)) + ' day'
;