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

0 vote172 views1 answer
Postgresql concat string with separator
SQL
0 vote144 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote156 views1 answer
Hallo
SQL
1 vote142 views1 answer
Input in mysql
SQL
0 vote145 views1 answer
Raiserror with nowait
SQL
0 vote142 views1 answer
Flask sqlalchemy remove duplicates
SQL
-1 vote161 views5 answers
Operator in sql
SQL
0 vote141 views1 answer
Search db for table name
SQL
4 votes146 views2 answers
Error loading MySQLdb module.
SQL
0 vote166 views1 answer
Primary key start from number
SQL