Received: from monterosa.urbanet.ch (monterosa.urbanet.ch [195.202.193.104]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f128Flq52892 for ; Fri, 2 Feb 2001 03:15:47 -0500 (EST) (envelope-from fsteffen@urbanet.ch) Received: (qmail 10524 invoked from network); 2 Feb 2001 08:15:45 -0000 Received: from unknown (HELO mail.urbanet.ch) (195.202.237.90) by monterosa.urbanet.ch with SMTP; 2 Feb 2001 08:15:45 -0000 Date: Fri, 2 Feb 2001 09:15:47 +0100 From: Florian Steffen To: pgsql-general@postgresql.org Subject: Timestamp accuracy Message-ID: <20010202091547.C634@samaris> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Balsa 1.0.1 Lines: 18 X-Archive-Number: 200102/29 X-Sequence-Number: 3862 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