Home Forums SQL Server 2005 T-SQL (SS2K5) Working Out Exact Age with DateDiff RE: Working Out Exact Age with DateDiff
Steve Jones - SSC Editor
SSC Guru
Points: 734604
More actions
July 20, 2009 at 8:49 am
#1027007
The reason is that you're subtracting years, and as Michael's logic shows, you need to account for where in the current year you are in relation to the date of birth.