how do i add a number of days to now()?

From: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To: pgsql-novice(at)postgresql(dot)org
Subject: how do i add a number of days to now()?
Date: 2005-12-18 11:44:01
Message-ID: do3hv7$dba$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi.

i am trying to do something like:
insert into table (limitDate) VALUES( now() + 2 days);

my problem is, how do i make postgresql understand that i want to add 2
days to the current time?

the column limitDate is of the timestamp type.

thanks
stig

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Srinivas Iyyer 2005-12-18 13:59:42 COPY command, linking foreign keys
Previous Message Danjel Jungersen 2005-12-18 10:44:00 Re: Login problem