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

6 votes223 views2 answers
How to get yesterday date in mysql
SQL
1 vote196 views1 answer
Scaffold mysql database
SQL
4 votes202 views2 answers
Postgresql default value
SQL
0 vote191 views1 answer
Sql server python connection
SQL
0 vote208 views1 answer
Sqlite to csv statement
SQL
2 votes216 views2 answers
Postgres trigger insert into another table
SQL
1 vote212 views1 answer
Oracle difference between two dates in years
SQL
0 vote205 views1 answer
How to reset the database value in SQL server
SQL
0 vote233 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote203 views1 answer
Mysql add comment to column
SQL