Re: Date addition using Interval

Sumita Biswas wrote:
> Hi Experts,
>
> I try to write the following in my Function and it works:
>
> ld_FromDateTemp := ld_FromDate + ''5 DAYS''::interval;
>
> But when I have to pass a parameter in the NUMBER of days(instead of 5)
> like 'li_NoOfDays'
>
> ld_FromDateTemp := ld_FromDate +  ''li_NoOfDays DAYS''::interval;

You want ... + (li_NoOfDays || '' DAYS'')::interval;

plpgsql doesn't interpolate variables like perl/php do.

--
   Richard Huxton
   Archonet Ltd