gilbert delarosa (9/20/2013)
This seems to work
DECLARE @DOB DATETIME
SET @DOB='9/19/2000'
SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)
Good try but it doesn't work...
DECLARE @DOB DATETIME
SET @DOB='01/01/2013'
SELECT FLOOR(DATEDIFF(DD,@DOB,'01/01/2014')/365.25)
Results:
---------------------------------------
0
(1 row(s) affected)
--Jeff Moden
Change is inevitable... Change for the better is not.