Re: timestamp - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: timestamp
Date
Msg-id Pine.LNX.4.44.0306071553560.2132-100000@peter.localdomain
Whole thread Raw
In response to timestamp  (Marc Cuypers <mail@mgvd.be>)
List 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@gmx.net


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Backups and restores.
Next
From: Peter Eisentraut
Date:
Subject: Re: Special characters in varchar/text fields