On Mon, 3 May 2004, 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;
This is a string containing 'li_NoOfDays DAYS' not
'<the value of li_NoOfDays> DAYS' so that's not going to work.
> If I write this way:
> ld_FromDateTemp := ld_FromDate + li_NoOfDays ''DAYS''::interval;
I think you probably want:
li_NoOfDays * interval '1 day'