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 <pierce@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
