Re: Problem with Now()? - Mailing list pgsql-general

From Robert L Mathews
Subject Re: Problem with Now()?
Date
Msg-id 20020815170559.C5A003FC6B7@mail1.tigertech.net
Whole thread Raw
In response to Problem with Now()?  ("Linn Kubler" <LKubler@ecw.org>)
List pgsql-general
At 8/15/02 8:29 AM, LKubler@ecw.org wrote:

>Ok, thanks.  Is it possible to turn that feature off?

If you never want fractional timestamps to appear in your data, specify
the field type as "timestamp(0)" when you create the table. The number in
parentheses is the optional maximum precision that the timestamp will
store.

See the first paragraph beneath the table at:

  http://www.postgresql.org/idocs/index.php?datatype-datetime.html


------------------------------------
Robert L Mathews, Tiger Technologies


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to synchronize database operations?
Next
From: Markus Wagner
Date:
Subject: Re: how to synchronize database operations?