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

• Next in forum: Output Column names in each Row along with the row Value
• Prev in forum: Re: problem about comparing date
• Thread view: Re: problem in date comparison

[Reply to this message]