DateDiff problem

[camaleonCHILE]

hi everybody, I've the next statement:

SELECT DATEDIFF(YY,'1977-11-15',GETDATE())

The difference between the 2 dates, in years, should be 27, but it returns 28.

¿ what's going on ?

Regards

 

[vongrunt]

<self-advertising>
faq183-5842

#2 explaines why, #10 probably gives results you want/expect.
</self-advertising>

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)