Informix DateDiff (going back in time)

[bcicsuci]

Is there another way to calculate the time and date based on the current time minus an hour and 5 minutes? I have a query that uses

x1.dtimecre > (current - interval (1:05) hour to minute )

in the where clause which works. However, I have a Perl job that uses a prepare statement that does not seem to accept the code listed above. Is there an alternative to the code used above?

Thank you,

 

[PHV]

You may try this:
x1.dtimecre > (current - 1 units hour - 5 units minute)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886