problem about comparing date

#1

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

#2

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 (AT) gmail (DOT) com"
<navneetkasulkar (AT) gmail (DOT) com> wrote:

Quote:

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

#3

Thanx but it was typing mistake
have a nice day

On Jun 26, 4:53 pm, Roy Harvey <roy_har... (AT) snet (DOT) net> wrote:

Quote:

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, "navneetkasul... (AT) gmail (DOT) com"

navneetkasul... (AT) gmail (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

problem about comparing date

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

problem about comparing date - 06-26-2007 , 05:34 AM

Re: problem about comparing date - 06-26-2007 , 06:53 AM

Re: problem about comparing date - 06-29-2007 , 04:00 AM