Re: Dynamic Query for System functions - now()

On Mon, 10 Nov 2003, Kumar wrote:

> select now()+ interval'1 month';  -- This is working fine.
>
> I wanna dynamically assign the interval number. i,e --> select now()+
> interval'n month';

If n is an integer, I'd suggest something likeselect now() + n * interval '1 month';
rather than messing around with the text of the interval literal.