1SELECT
2 BRTHDATE AS BIRTHDAY
3 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25) AS AGE_NOW
4 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW
5FROM
6 "Database name".dbo.EMPLOYEES EMP
7WHERE 1 = (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25))
8 -
9 (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25))
10