|
|
Posted by Roy Harvey on 06/26/07 11:54
OK, I guess you noticed that you used the same date for both.
What is the datatype of orderdate?
Roy Harvey
Beacon Falls, CT
On Tue, 26 Jun 2007 10:42:30 -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/21/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]
|