• Just bumped on this:

    DECLARE @dob datetime

    SET @dob='1992-01-09 00:00:00'

    SELECT DATEDIFF(YEAR, '0:0', getdate()-@dob)

    Works ok. Who can explain '0:0' ?