Code: SQL
SELECT * FROM employees WHERE to_char(birth_date,'ddd')::int-to_char(now(),'DDD')::int BETWEEN 0 AND 8 ORDER BY birth_date;

One more method is to find the current week of the year, and search for all birthdays in the same week!