Timestamp accuracy - Mailing list pgsql-general

From Florian Steffen
Subject Timestamp accuracy
Date
Msg-id 20010202091547.C634@samaris
Whole thread Raw
List pgsql-general
Hi,

The user manual said the Timestamp type has a microsecond accuracy, but how can
I display the results of a query with microseconds ?
Without formatting the output has an accuracy of 10^-2 second, and with
formatting it is even worse since the formatting strings do not accept anything
under the second.

SQL example:

     > create table test_ts (ts timestamp);
     > insert into test_ts values ('2001-2-2 00:00:00.123456789');
     > select * from test_ts;

           ts
    ---------------------------
    2001-02-02 00:00:00.12+01


pgsql-general by date:

Previous
From: "Michael Miyabara-McCaskey"
Date:
Subject: RE: Sizing of LARGE databases.
Next
From: Ferruccio Zamuner
Date:
Subject: DEBUG strings