Posted by navneetkasulkar@gmail.com on 06/29/07 09:00

Thanx but it was typing mistake
have a nice day

On Jun 26, 4:53 pm, Roy Harvey <roy_har...@snet.net> wrote:
> What possible value can be BOTH >= AND < the SAME date? You need to
> add a day to the second date, make it 6/21.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Tue, 26 Jun 2007 10:34:51 -0000, "navneetkasul...@gmail.com"
>
> <navneetkasul...@gmail.com> wrote:
> >I have a problem in this query:
>
> >select order from ordertable
> >where orderdate >= '06/20/2007' and orderdate < '06/20/2007'
>
> >this query do not return any record
> >although there are records in the table matching the query
>
> >please help me

• Next in forum: Re: problem in date comparison
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Re: problem about comparing date

[Reply to this message]