View Incident Report

Serious

Reported By: Kumar Manuel
Reported On: 3/11/2002
For: Version 3.07 Build 1

# 1056 Specifying Time Constants in Filters or SQL with No Seconds Causes Incorrect Results

MyTable is has a Time field (ActTime), populated with various times from 03:00 AM to 09:00 PM. The following query returns NO records:

select * from MyTable where ActTime < '11:00 PM'

Comments and Workarounds

Workaround is to specify the seconds in the time constant.

Resolution

Fixed Problem on 3/12/2002 in version 3.08 build 1

More Support Options