Re: timestamp

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Marc Cuypers <mail(at)mgvd(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp
Date: 2003-06-07 15:07:05
Message-ID: 20030607150705.GA8873@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 04, 2003 at 14:43:31 +0200,
Marc Cuypers <mail(at)mgvd(dot)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' .

In response to

  • timestamp at 2003-06-04 12:43:31 from Marc Cuypers

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Steffen 2003-06-07 15:17:27 Re: update phenomenom
Previous Message Tom Lane 2003-06-07 15:06:10 Re: Backups and restores.