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 vote317 views1 answer
Safe mysql
SQL
2 votes322 views1 answer
Oracle list grants on procedure
SQL
0 vote326 views1 answer
Mysql milliseconds
SQL
3 votes356 views2 answers
Oracle sql first day of month
SQL
0 vote315 views1 answer
Dnsmasq.conf location macos
SQL
0 vote309 views1 answer
Sql select column names starting with
SQL
0 vote331 views1 answer
Select into table variable
SQL
6 votes399 views3 answers
What is where in sql
SQL
0 vote402 views1 answer
Redshift running queries
SQL
15 votes336 views5 answers
Show tables in oracle
SQL