Subject Re: [IBO] Filtering a Time Field
Author Helen Borrie
At 03:58 AM 10/08/2005 +0000, you wrote:
>Using a TIBOQuery, when I try to filter a time field, I continually
>get error messages. It seems that setting the filter property like this:
>START_TIME < '11:00 AM'
>should work, but I get a "conversion error from string 11:00 AM". I
>can't get anything else to work either. Is there a way to do this?

Yes - filters have to be valid SQL search arguments. SQL doesn't know
about GUI interpretations like 'AM' and 'PM'. Use the 24-hour clock and a
datetime literal of the format 'hh:nn:ss.zzzz':

START_TIME < '11:00:00.000''