Re: [SQL] interval +variable

2005-03-10 Thread AL� �EL�K
+ '1 days'::interval ""Fatih Cerit"" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazdý:[EMAIL PROTECTED] > Dear all > > Is there anyone at there who knows howto use dateadd in pgsql. I have a > problem in my function that is like this ; > > Select into futuredate now() + interval '30 days'; <

Re: [SQL] interval +variable

2005-03-09 Thread Bruno Wolff III
On Wed, Mar 09, 2005 at 10:58:05 +0200, Fatih Cerit <[EMAIL PROTECTED]> wrote: > Dear all > > Is there anyone at there who knows howto use dateadd in pgsql. I have a > problem in my function that is like this ; > > Select into futuredate now() + interval '30 days'; <- this is ok > but how can

Re: [SQL] interval +variable

2005-03-09 Thread Michael Fuhr
On Wed, Mar 09, 2005 at 10:58:05AM +0200, Fatih Cerit wrote: > Is there anyone at there who knows howto use dateadd in pgsql. I have a > problem in my function that is like this ; > > Select into futuredate now() + interval '30 days'; <- this is ok > but how can I use a variable intead of '30 d

[SQL] interval +variable

2005-03-09 Thread Fatih Cerit
Dear all Is there anyone at there who knows howto use dateadd in pgsql. I have a problem in my function that is like this ; Select into futuredate now() + interval '30 days'; <- this is ok but how can I use a variable intead of '30 days':( Thanks ---(end of broadcas