Thread: Are there any changes to INTERVAL in 7.2

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




_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

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 7.1.

From the release notes:

     * The  timestamp(),  time(),  and  interval()  functions  are no
longer available. Instead of timestamp(), use timestamp 'string' or CAST.

Try CAST(term || 'year' as INTERVAL)