Hi,
Try this
select mem_name from T1 where date_of_birth between getdate() and DATEADD(day,
6,getdate())
Let me know if any probs
Regards,
RK
yours_truly_jaan <[EMAIL PROTECTED]> wrote:
Friends,
I'm facing a big problem.
I'm having a table T1 which having fields mem_name and date_of_birth.
I want a SQL query which should give me mem_name whose birthdays are
today and in next 6 days i.e.
when i will run this query today i.e. on 16-feb-2005 it should give me
the names of all the persons whose birthday lies in between 16-feb and
22-feb.
Its really urgent.
Thnx in advance.
Yahoo! Groups SponsorADVERTISEMENT
document.write('');
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
