Postgres Pro
Downloads
Home   >   mailing lists

Community Driver : Time data is getting truncated while read - Mailing list pgsql-jdbc

From Dave, Mohit
Subject Community Driver : Time data is getting truncated while read
Date
Msg-id DM6PR03MB4619CBB3A4FF0D448AE397BCA1FC0@DM6PR03MB4619.namprd03.prod.outlook.com
Whole thread Raw
Responses Re: Community Driver : Time data is getting truncated while read  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-jdbc
Tree view

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 :

 

 

 

Data read from driver is :

 

 

 

 

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

Attachment

pgsql-jdbc by date:

Previous
From: adrklos
Date:
Subject: [pgjdbc/pgjdbc] 9caf14: refactor: adding missing OIDs (#1750)
Next
From: Dave Cramer
Date:
Subject: [pgjdbc/pgjdbc] 2218dd: Fix: change assertTrue to assertEquals. Surround w...