On Wed, 4 Jun 2003, Marc Cuypers wrote:
> Hi,
>
> How do insert a timestamp in a timestamp field.
>
> insert into table (tt) values (now()+100)
>
> doesn't seem to work
Here's a page that might help:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-datetime.html
A quick hint,
select now() + interval '1 hour';
select now() + interval '45 seconds';