Openedge syntax for TIME minus 4 hours

I am trying to figure out how to write a Openedge query where i can look back 4 hours. i have struggled with the TIME syntax before. If i understand correctly, the TIME representation in Openedge is in seconds starting from midnight. The query i am trying to write would run 4 times a day, looking back 4 hours.

Is there any way to do this using TIME? Maybe i have to write 4 different queries that only pull records starting at a specific time?

Thanks very much for any help i can get, it is greatly appreciated!

Martin

Continue reading...