Go4Expert - View Single Post

pradeep

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!

pradeep Team Leader
16Feb2007,10:53
	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!