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

1 vote219 views1 answer
Apex select list ORA-20999
SQL
3 votes196 views1 answer
Oracle list dates without weekends
SQL
6 votes195 views4 answers
Sqlite drop table
SQL
0 vote200 views1 answer
Sum value by month sql
SQL
0 vote284 views1 answer
Postgressql uuid
SQL
11 votes304 views1 answer
Oracle insert from select
SQL
0 vote224 views1 answer
Populate db from command line postgres
SQL
0 vote200 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote240 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote232 views1 answer
Convert int to varchar sql
SQL