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
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 |