Hey, Finally I am done with my problem , this works fine in postgresql. But it will not work in mysql as mysql doesnt support "::" ....
It should be 359 not 259 in above post
I tried order by EXTRACT( DOY FROM birth_date ) which does the similar work which you said , but it will also give the problem for last week of...
Hey Pradeep, Your query is good and it will work nice except in one condition, Think that today is 27 december and I am showing birthdays...
Hello Pradeep, Using order by birth_date will not solve my problem, consider the following table One | 02/18/1981 Two | 02/17/1985...
Well, I have find out the query which shows the coming week birthdays but the only problem is it is not showing in the order. SELECT * FROM...
Hey Pradeep, I am using PostgreSQL. Khwab
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...
Separate names with a comma.
