Community Driver : Time data is getting truncated while read

From: "Dave, Mohit" <mdave(at)informatica(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Cc: "Dhuvad, Rahul" <rdhuvad(at)informatica(dot)com>
Subject: Community Driver : Time data is getting truncated while read
Date: 2020-11-23 11:02:29
Message-ID: DM6PR03MB4619CBB3A4FF0D448AE397BCA1FC0@DM6PR03MB4619.namprd03.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Team,

We are using PostgreSQL community driver (postgresql-42.2.6), we have observed truncation for time data type while reading.

The scenario is that the data for the table created with datatype time(4),time(5),time(6) is getting truncated beyond milli seconds to limit it to milli seconds.

Please find the screenshot attached.

Original data is :

[cid:image001(dot)png(at)01D6C1B1(dot)EB47C610]

Data read from driver is :

[cid:image002(dot)png(at)01D6C1B1(dot)EB47C610]

We can see the time is truncated to millisecond values. This can be easily re-pro at will.

Please raise a bug for this and do needful to provide fix for same.

Thanks
Mohit

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2020-11-23 16:11:36 [pgjdbc/pgjdbc] 2218dd: Fix: change assertTrue to assertEquals. Surround w...
Previous Message adrklos 2020-11-18 13:24:37 [pgjdbc/pgjdbc] 9caf14: refactor: adding missing OIDs (#1750)