I'm trying to pull records which were created in the last 30 minutes, but I'm confused with Informix datetimes. My where statement is listed below.
row_date is a date type, starttime is a small integer, a typical value for startime is 1800.
WHERE
(hvdn.row_date = today -1 and (hvdn.starttime)...