|
|
Posted by Roy Harvey on 06/26/07 11:53
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, "navneetkasulkar@gmail.com"
<navneetkasulkar@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
Navigation:
[Reply to this message]
|