Posted by MikeJ on 06/26/07 17:50

Looking at ur dates the 2nd part of the and >= should and will only have
items
before 06/21 because time is involved so 06/21/2007 is as of midnite on the
20th
you mite wanna make 06/21/2007 to 06/22/2007 and you should get everything
upto midnite
on the 21st
MJ

<navneetkasulkar@gmail.com> wrote in message
news:1182854550.095525.236690@o11g2000prd.googlegroups.com...
>I have a problem in this query:
>
> select order from ordertable
> where orderdate >= '06/20/2007' and orderdate < '06/21/2007'
>
> this query do not return any record
> although there are records in the table matching the query
>
> please help me
>

[Back to original message]