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

7 votes246 views2 answers
Where keyword sql
SQL
0 vote245 views1 answer
Get current date data in mysql
SQL
0 vote228 views1 answer
How to reset table in sql server
SQL
0 vote240 views2 answers
How to add CHECK constraint to a column in postgres
SQL
1 vote180 views1 answer
Unique vs distinct sql
SQL
0 vote236 views1 answer
Primary key multiple colums
SQL
0 vote242 views1 answer
List all indexes postgres
SQL
0 vote236 views1 answer
Delete a record from a table sqlite3
SQL
0 vote229 views1 answer
How to get data between a last week in mysql
SQL
0 vote187 views1 answer
Calculate discount from original price sql
SQL