Re: timestamp

From: "Vincent Hikida" <vhikida(at)inreach(dot)com>
To: "Marc Cuypers" <mail(at)mgvd(dot)be>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp
Date: 2003-06-07 03:34:37
Message-ID: 01a701c32ca5$bb24e850$6601a8c0@HOMEOFFICE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Try

INSERT INTO tt VALUES (now()+100);

Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"

www.UrbanaSoft.com

----- Original Message -----
From: "Marc Cuypers" <mail(at)mgvd(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, June 04, 2003 5:43 AM
Subject: [GENERAL] timestamp

> Hi,
>
> How do insert a timestamp in a timestamp field.
>
> insert into table (tt) values (now()+100)
>
> doesn't seem to work
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

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

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Fitzmyers 2003-06-07 04:56:38 Re: Backups and restores.
Previous Message Tom Lane 2003-06-07 03:16:02 Re: Optimizer failure on integer column?