Sql select upcoming birthdays

SELECT 
  BRTHDATE AS BIRTHDAY
 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25) AS AGE_NOW
 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW
FROM 
  "Database name".dbo.EMPLOYEES EMP
WHERE 1 = (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25))
          -
          (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25))

Source: stackoverflow.com

Similar codes

0 vote347 views1 answer
Sql delete caracter list
SQL
0 vote365 views1 answer
Write SQL in ruby on rails
SQL
10 votes297 views1 answer
Oracle dependency
SQL
0 vote325 views1 answer
Add column in sql server ubuntu
SQL
23 votes338 views2 answers
Query to delete a database in mysql
SQL
0 vote339 views1 answer
Oracle list of long running queries
SQL
0 vote319 views1 answer
10000000000000000000 am to meters
SQL
1 vote346 views4 answers
Psql check tables command
SQL
1 vote354 views1 answer
Drop primary key oracle
SQL
1 vote304 views3 answers
String to int mysql
SQL