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

15 votes278 views6 answers
Laravel db transaction
SQL
0 vote248 views1 answer
Get only structure database mysql
SQL
0 vote251 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote287 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote237 views1 answer
Mysql select row with min date
SQL
0 vote280 views1 answer
Check database restore status sql script
SQL
0 vote252 views1 answer
Pl sql search in all packages
SQL
1 vote224 views2 answers
Procedure pl/sql
SQL
0 vote258 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
9 votes245 views1 answer
Identity insert on sql server
SQL