SQL server 2000 bug??

[haiwen]

Hello, everyone,

I have table(t1) with one column endTime(datetime type),
suppose there is one record with the endTime(2/24/2003
11:45 AM)

If I use the query
select *
from t1
where endTime<'2/24/2003 11:50 AM'

I can get the record. But if the query change to:
select *
from t1
where endTime<'2/24/2003 12:50 AM'
I can not get the record?? obviously, '2/24/2003 11:45 AM'
is less than '2/24/2003 12:50 AM'

Could any one help me?

Haiwen

 

[Angel Saenz-Badillos[MS]]

try 12:50PM

 

[haiwen]

Hello,
I get it, thanks a lot,

haiwen

-----Original Message-----
try 12:50PM

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

Hello, everyone,

I have table(t1) with one column endTime(datetime type),
suppose there is one record with the endTime(2/24/2003
11:45 AM)

If I use the query
select *
from t1
where endTime<'2/24/2003 11:50 AM'

I can get the record. But if the query change to:
select *
from t1
where endTime<'2/24/2003 12:50 AM'
I can not get the record?? obviously, '2/24/2003 11:45 AM'
is less than '2/24/2003 12:50 AM'

Could any one help me?

Haiwen

.

 

[Stuart Rivenbark]

At 12 Noon, the time becomes 12:00 PM (not AM), So, change
your query to 12:50 PM and you should find your record.