Re: timestamp - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: timestamp
Date
Msg-id 20030607150705.GA8873@wolff.to
Whole thread Raw
In response to timestamp  (Marc Cuypers <mail@mgvd.be>)
List pgsql-general
On Wed, Jun 04, 2003 at 14:43:31 +0200,
  Marc Cuypers <mail@mgvd.be> wrote:
> Hi,
>
> How do insert a timestamp in a timestamp field.
>
> insert into table (tt) values (now()+100)
>
> doesn't seem to work

You probably want something like now() + '100 seconds' .

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backups and restores.
Next
From: Doug McNaught
Date:
Subject: Re: Backups and restores.