SQL server 2000 bug??

  • Thread starter Thread starter haiwen
  • Start date Start date
H

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
 
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.
haiwen said:
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
Click to expand...


.
Click to expand...
 
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.
 
Back
Top