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 f13FLoq10894 for ; Sat, 3 Feb 2001 10:21:50 -0500 (EST) (envelope-from fsteffen@urbanet.ch) Received: (qmail 14710 invoked from network); 3 Feb 2001 15:21:45 -0000 Received: from unknown (HELO mail.urbanet.ch) (195.202.205.190) by monterosa.urbanet.ch with SMTP; 3 Feb 2001 15:21:45 -0000 Date: Sat, 3 Feb 2001 16:21:41 +0100 From: Florian Steffen To: pgsql-sql@postgresql.org Subject: Timestamp accuracy Message-ID: <20010203162141.A3886@samaris.urbanet.ch> References: <20010202091547.C634@samaris> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit In-Reply-To: <20010202091547.C634@samaris>; from fsteffen@urbanet.ch on Fri, Feb 02, 2001 at 09:15:47 +0100 X-Mailer: Balsa 1.1.0 Lines: 19 X-Archive-Number: 200102/19 X-Sequence-Number: 1187 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 Florian