Hi
The following query works very well in 7.1 but does not work under 7.2
SELECT order_id FROM order
WHERE order_date + INTERVAL
(term ||'year') < current_timestamp;
Please let me know if there are any changes to INTERVAL in 7.2
Thanks for your help.
Brenda
The following query works very well in 7.1 but does not work under 7.2
SELECT order_id FROM order
WHERE order_date + INTERVAL
(term ||'year') < current_timestamp;
Please let me know if there are any changes to INTERVAL in 7.2
Thanks for your help.
Brenda