-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Hibalaji
Message 6 in Discussion
hi,
The solution to your below query is
Hi, guys, I have a table which contains 3 fields: value, date1,date2
In my application I would provide a date which will check if it is between
the dates 'date1' and 'date2' and if so, will return the corresponding
'value' as result. Could someone please tell me how to do this. Regards
Arnab
select value
from tablename
where (date1 between provideddate and provideddate
or date2 between provideddate and providedate)
Note: The bracket is opening bracket and closing for where is imp.
Hope the solution works for you, if i'm wrong, then sorry & correct me with
revert mail.
cheers
balaji
>From: "arnab" <[EMAIL PROTECTED]>
>Reply-To: "MumbaiUserGroup" <[email protected]>
>To: "MumbaiUserGroup" <[email protected]>
>Subject: sql issue
>Date: Tue, 23 May 2006 03:05:35 -0700
>
>
>
>
>
>
>
>
>
>
>
>
> New Message on MumbaiUserGroup
>
>
>
>
>
>
>
> sql issue
>
>
>
>
> Reply
>
>
>
>
>
> Reply to Sender
> Recommend
>
> Message 1 in Discussion
>
>
>
>
>
>
>
> From:
> arnab
>
>
>
>
> Hi, guys, I have a table which contains 3 fields: value,
>date1,date2 In my application I would provide a date which will check if
>it is between the dates 'date1' and 'date2' and if so, will return the
>corresponding 'value' as result. Could someone please tell me how to do
>this. Regards Arnab
>
>
>
>
>
>
> View other groups in this category.
>
>
>
>
>
>
>
>
>
>
>
>
>
>Also on MSN:
>Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily
>Horoscopes
>
>
>
>
>
>
>
>
>
>
> To stop getting this e-mail, or change how often it
>arrives, go to your E-mail Settings.
>
>
> Need help? If you've forgotten your password,
> please go
>to Passport Member Services.
>
> For other questions or feedback, go to our
> Contact Us
>page.
>
>
> If you do not want to receive future e-mail
> from this
>MSN group, or if you received this message by mistake, please click the
>"Remove" link below. On the pre-addressed e-mail message that opens, simply
>click "Send". Your e-mail address will be deleted from this group's mailing
>list.
>
>
> Remove my e-mail address from MumbaiUserGroup.
>
>
>
>
>
>
>
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
