| From: | Robert L Mathews <lists(at)tigertech(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with Now()? |
| Date: | 2002-08-15 17:06:00 |
| Message-ID: | 20020815170559.C5A003FC6B7@mail1.tigertech.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 8/15/02 8:29 AM, LKubler(at)ecw(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wagner | 2002-08-15 17:18:14 | Re: how to synchronize database operations? |
| Previous Message | Tom Lane | 2002-08-15 16:47:06 | Re: how to synchronize database operations? |