Seconds precision in timestamp columns

From: "Luiz E(dot) P(dot) Fernandes" <lepfer(at)uol(dot)com(dot)br>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Seconds precision in timestamp columns
Date: 2021-07-16 19:03:53
Message-ID: 187cc78d-fc34-aaa9-aeb0-f0045b9b4ce8@uol.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,

In the dvdrental example database, there is a column named
'payment_date' on the 'payment' table and columns 'rental_date' and
'return_date' on the 'rental' table.  These columns appear on the
information_schema.columns view with identical specifications: datatype
= 'timestamp without timezone', datetime_precision = 6. However, a
select on table 'payment' presents column 'payment_date' with 6
fractional digits, while a select on table 'rental' presents columns
'rental_date' and 'return_date' without fractional digits.

select payment_date from payment limit 1;
--> for example, payment_date: '2007-02-15 22:25:46.996577'

select rental_date, return_date from rental limit 1;
--> for example, rental_date: '2005-05-24 22:54:33'

This happens in PgAdmin and also in the query values returned by
PQgetvalue(), with LibPq.
What defines this seconds precision?  Is it possible to find the number
of fractional digits that will be returned in a datetime column, before
calling PQgetvalue()?

Thanks in advance.

Luiz Fernandes

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2021-07-17 14:04:11 Re: Seconds precision in timestamp columns
Previous Message Greg Sabino Mullane 2021-05-21 21:36:35 DBD::Pg version 3.15.0 released