Got (1,1) on 2000

Here is one example:

DECLARE @Date1 DATETIME, @Date2 DATETIME

SET @Date1 = '2008-05-09 15:59'

SET @Date2 = '2008-05-11 16:32'

SELECT convert(varchar(5),DATEDIFF(minute, @Date1, @Date2)/60) + ':' + convert(varchar(2),datediff(minute, @Date1, @Date2)%60)

Hope this will help you to...

It works fine in 2000. Arghhh credits lost :doze:

I also ran all 3 queries for my DOB and 2nd was correct, both 1st and 3rd were wrong.