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

26 votes239 views10 answers
Insert in to table sql
SQL
0 vote369 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
11 votes320 views1 answer
Ddl view
SQL
16 votes289 views4 answers
Sort by sql
SQL
3 votes313 views1 answer
Get current month last date in sql server
SQL
0 vote307 views1 answer
Kill mysqld_safe process mariadb
SQL
2 votes300 views1 answer
Query any digits record
SQL
8 votes300 views2 answers
Select table column name in sql
SQL
3 votes293 views2 answers
Oracle apex view logs
SQL
0 vote304 views1 answer
Mysql make date from 2 column
SQL