Informix DateDiff (going back in time)
Informix DateDiff (going back in time)
(OP)
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,
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,
RE: Informix DateDiff (going back in time)
x1.dtimecre > (current - 1 units hour - 5 units minute)
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?