Re: timestamp

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Marc Cuypers <mail(at)mgvd(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp
Date: 2003-06-07 16:01:05
Message-ID: Pine.LNX.4.44.0306071553560.2132-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Cuypers writes:

> How do insert a timestamp in a timestamp field.
> insert into table (tt) values (now()+100)
> doesn't seem to work

What is now()+100 supposed to mean? Maybe you mean now() + interval '100
seconds' or some other unit.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

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

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-06-07 16:01:28 Re: How to merge 3 databases in one database quickly
Previous Message Henrik Steffen 2003-06-07 16:00:39 Re: update phenomenom