select 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

declare @d datetime = '1932-04-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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results