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

On Jun 26, 3:42 pm, "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/21/2007'
>
> this query do not return any record
> although there are records in the table matching the query
>
> please help me

Hi friends

Thanks for your reply

the problem is solved
i change the datatype of the column to 'datetime' from 'varchar'
and it works
thanx once again
and have a nice day

[Back to original message]