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

11 votes125 views2 answers
How to import mysql database command line
SQL
6 votes118 views5 answers
Alter table oracle
SQL
32 votes137 views6 answers
Rename column mysql
SQL
6 votes82 views2 answers
Generate c# class from sql server table
SQL
1 vote145 views1 answer
Oracle drop temporary table
SQL
0 vote125 views1 answer
Mysql aspas simples
SQL
0 vote109 views1 answer
Back up stored procedures mysql
SQL
-1 vote97 views1 answer
Plsql while
SQL
0 vote121 views1 answer
Rename constraint postgresql
SQL
0 vote126 views1 answer
T-SQL Never ending DELETE
SQL