DATEDIFF Produces Unflattering Ages
Explains how to use the Transact-SQL DATEDIFF function to calculate ages from dates of birth, as at today’s date or on a specific date. It explains the common mistake that can be made when using the function; namely that DATEDIFF counts the number of date boundaries in the interval and not the actual timespan. Continue reading