how do i add a number of days to now()? - Mailing list pgsql-novice

From stig erikson
Subject how do i add a number of days to now()?
Date
Msg-id do3hv7$dba$1@floppy.pyrenet.fr
Whole thread Raw
Responses Re: how do i add a number of days to now()?
List 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

pgsql-novice by date:

Previous
From: "Stephen Simpson"
Date:
Subject: Error connecting to database
Next
From: max chin
Date:
Subject: Questions about server.