Hello Feherke,
First of all thank you very much for helping me with the query, your query works fine but now I want to display all the birthdays in ascending order so What I have done is
select * from employee where to_char(birth,'ddd')::int-to_char(now(),'DDD')::int between 0 and 6 ORDER BY...
Hello All,
I want to display the employees list whose birth day is coming in next week, in database I am storing birth date in MM/DD/YYYY format.
Anyone can help me with this?
Thank you
Khwab
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.