Re: [ADMIN] Are there any changes to INTERVAL in 7.2

2002-11-11 Thread Stephan Szabo
On Mon, 11 Nov 2002, Mr OCP wrote: > Hi > > The following query involving INTERVAL 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; > > Are there any changes to this functionality in 7.2 from

[ADMIN] Are there any changes to INTERVAL in 7.2

2002-11-11 Thread Mr OCP
Hi The following query involving INTERVAL 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; Are there any changes to this functionality in 7.2 from 7.1. Please comment Thanks Khat