Clarify: default precision on timestamps is 6

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "him(at)nathanmlong(dot)com" <him(at)nathanmlong(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Clarify: default precision on timestamps is 6
Date: 2023-10-13 14:32:02
Message-ID: CAKFQuwb5hbSCy_zspr_MqqoE-k6MaGt47j1QBFNY-pn9Px8Zqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Friday, October 13, 2023, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> both of them round any precision
> beyond microseconds, and neither returns timestamps with greater precision
> than the value that was inserted.
>

That is precisely what a no default with maximum of six means. If we say
the default is six that would imply storage of less precise values pads
significant zeros until there are six.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Nathan Long 2023-10-13 14:54:22 Re: Clarify: default precision on timestamps is 6
Previous Message PG Doc comments form 2023-10-13 10:35:30 Clarify: default precision on timestamps is 6