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 vote150 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
8 votes149 views1 answer
Today minus 15 days postgresql
SQL
12 votes150 views3 answers
Duplicate a column in sql
SQL
0 vote171 views2 answers
Transaction php
SQL
0 vote169 views1 answer
Oracle concat datetime
SQL
3 votes183 views1 answer
Set default today mysql
SQL
1 vote152 views1 answer
Mysql show table character set
SQL
0 vote144 views1 answer
Oracle free up space in tablespace
SQL
1 vote154 views2 answers
Postgresql get difference in hours between two dates
SQL
3 votes217 views1 answer
How to get yesterday date in sql
SQL