0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

DECLARE @d datetime = '1932-12-29 00:00:00.000'

SELECT datediff(year, @d, getdate()) - 
CASE WHEN dateadd(year,1900-year(@d) ,@d) > 
dateadd(year,1900-year(getdate()) ,getdate()) 
THEN 1 else 0 END AGE

fork query

edited oct 31 12

created oct 31 12 anonymous