Hi, thank you very much, this worked flawlessly, this is the final code: execute 'select CURRENT_TIMESTAMP + $1 * interval ''1 day''' into newexpdate using expdays;
works perfect, thanks a ton! On 15 December 2013 18:23, John R Pierce <pie...@hogranch.com> wrote: > On 12/15/2013 4:17 PM, Andreas Brandl wrote: > >> select current_timestamp, current_timestamp + interval '2' day; >> > > that should be interval '2 day' (note the ' moved), and for a variable > number passed as a parameter, try... > > select current_timestamp, current_timestamp + $1 * interval '1 day'; > > note this will work with values in hours, months, any unit, really. > > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
