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

15 votes199 views3 answers
Mysql update add to existing value
SQL
0 vote240 views1 answer
Trigger stock phpmyadmin
SQL
3 votes178 views1 answer
Difference sql vs mysql
SQL
1 vote196 views1 answer
Duplicating a MySQL table with all the data Command
SQL
2 votes241 views1 answer
Match in sql server
SQL
1 vote195 views1 answer
How to subtract from the value of a table in sql
SQL
1 vote185 views1 answer
Find logged in users mysql
SQL
0 vote193 views1 answer
Show the colums of table sql
SQL
0 vote205 views1 answer
Mysql grant grant option
SQL
0 vote177 views1 answer
View acl table oracle
SQL