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,