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

8 votes99 views1 answer
Today minus 15 days postgresql
SQL
0 vote95 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote100 views1 answer
Insufficient memory to excute the sql query
SQL
2 votes98 views2 answers
Spring import sql
SQL
1 vote102 views2 answers
Difference between in and between in sql
SQL
1 vote107 views1 answer
Sql server get users
SQL
0 vote113 views1 answer
Oracle search in date columns
SQL
0 vote98 views1 answer
How to connect pgadmin with excel
SQL
42 votes170 views6 answers
Sql query duplicate rows
SQL
1 vote135 views1 answer
Sql server set variable if exists
SQL