Thread: odd result set

odd result set

From
garry saddington
Date:
I have the following result from the sql below. Can anyone help by
explaining why the last record could be returned. Periodstart and
periodend are time data types. I have tried to cast '10.35' to a time
type with the same results.

________________________________________________________________________
     Periodid
   Periodnumber
   Periodstart
    Periodend
1
1
09:00:00.00
09:35:00.00
2
2
09:35:00.00
09:10:00.00
3
3
10:20:00.00
10:55:00.00
4
4
10:50:00.00
11:30:00.00

________________________________________________________________________
SQL used:
select * from periods
where '10:35' > periodstart

Kind regards
Garry