Using time in a query

robleer

Hi, just a simple question, but I cannot figure it out.

I have a querywhich has to filter on a time field. I have a BO with a Timestamp field called StartTime.

My query is this:

FIND TESTBO WHERE TestBO.StartTime < 14:00

Somehow it does not work, I get no results. I tried:

FIND TESTBO WHERE TestBO.StartTime < 14:00
FIND TESTBO WHERE TestBO.StartTime < '14:00'
FIND TESTBO WHERE TestBO.StartTime < '1970/01/01T14:00'
FIND TESTBO WHERE TestBO.StartTime < '1970/01/01 14:00'
FIND TESTBO WHERE TestBO.StartTime < AS_TIMESTAMP(14:00)
FIND TESTBO WHERE AS_TIMESTAMP(TestBO.StartTime) < AS_TIMESTAMP(14:00)
a.s.o.

Should be simple, but anyone who can help me??

TIA

Rob

tford

Have you considered putting a timestamp field in LoggedInRegularUser or SystemSettings and comparing to that value?

BLOMASKY

The problem is, that TimeStamps (at least on MSSQL) are stored as smallDates, so they have both a DATE and a TIME part. That is why you can't just compare to a time. There are a few alternatives but most have to do with your db design. What are you using this field for?

bruce

kklosson

Same as above. Look at the values in the database to see how to format for a correct evaluation.

robleer

Ok, I understand and I used the tFord solution for now. Thanks !