Rashid Khan

Rashid Khan

  • NA
  • 159
  • 0

upcoming biethday query in SQL

May 1 2010 2:16 AM
no my Altaf Bro.
i think u didn't get my point.
my query is checking all this things. but when the days remain less than 10 then is never goes and check from the upcoming month days.
i mean. for example my dob is 30 April. so it starts give me msg from 20th April. (because it comes in next 10 day defined period) but at 21st April that 10 days period cover 1st May also, but it not calculate  cause of month didn't change.  as i told i want data like we see in orkut nd other social websites. how they filter the dob nd fetch it form database
i hope this may clear my requirement i gone though all my efforts but stuck in month case.
please if anyone knows abt it bd understand my problem please please tell me the solution
Thanks

Answers (3)