Timestamp accuracy

From: Florian Steffen <fsteffen(at)urbanet(dot)ch>
To: pgsql-sql(at)postgresql(dot)org
Subject: Timestamp accuracy
Date: 2001-02-03 15:21:41
Message-ID: 20010203162141.A3886@samaris.urbanet.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-03 16:41:44 Re: trying to back up a database
Previous Message Andy Taylor 2001-02-03 15:18:07 Problems with Relationships in SQL7

Browse pgsql-sql by date

  From Date Subject
Next Message Tod McQuillin 2001-02-03 17:09:41 Bug with rules in 7.0.3?
Previous Message <No Name> 2001-02-03 14:50:32 Packages to Install