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