Weird Date Rounding

SQL Server 7.0

The following SQL:

SELECT TOP 100 PERCENT fldTSRID, fldDateEntered
FROM tblTSRs WITH (NOLOCK)
WHERE ((fldDateEntered >= CONVERT(DATETIME, '2003-11-21 00:00:00',
102))
AND
(fldDateEntered <= CONVERT(DATETIME, '2003-11-23 23:59:59', 102)))

returns this record:

fldTSRID: 4
fldDateEntered: 24/11/2003

Hello? How is 24/11/2003 <= '2003-11-23 23:59:59'?

I tried decrementing the second predicate by seconds:

(fldDateEntered <= CONVERT(DATETIME, '2003-11-23 23:59:30', 102)))

returns the record, but

(fldDateEntered <= CONVERT(DATETIME, '2003-11-23 23:59:29', 102)))

does NOT.

What is happening here?

Edward

============================

TABLE DEFINITION:

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_tblTSRNotes_tblTSRs]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[tblTSRNotes] DROP CONSTRAINT FK_tblTSRNotes_tblTSRs
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblTSRs]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[tblTSRs]
GO

CREATE TABLE [dbo].[tblTSRs] (
[fldTSRID] [int] IDENTITY (1, 1) NOT NULL ,
[fldDealerID] [int] NOT NULL ,
[fldWorkshopGroupID] [int] NULL ,
[fldSubjectID] [int] NULL ,
[fldReasonID] [int] NULL ,
[fldFaultID] [int] NULL ,
[fldContactID] [int] NULL ,
[fldMileage] [int] NULL ,
[fldFirstFailure] [smalldatetime] NULL ,
[fldNumberOfFailures] [int] NULL ,
[fldTSRPriorityID] [int] NULL ,
[fldTSRStatusID] [int] NULL ,
[fldAttachedFilePath] [char] (255) NULL ,
[fldFileAttached] [smallint] NOT NULL ,
[fldFaultDescription] [ntext] NULL ,
[fldFaultRectification] [ntext] NULL ,
[fldEmergency] [int] NOT NULL ,
[fldDateEntered] [smalldatetime] NOT NULL ,
[fldEnteredBy] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO