Обсуждение: Community Driver : Time data is getting truncated while read

Поиск
Список
Период
Сортировка

Community Driver : Time data is getting truncated while read

От
"Dave, Mohit"
Дата:

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

Вложения

Re: Community Driver : Time data is getting truncated while read

От
Dave Cramer
Дата:
Please try the latest driver and if the problem still persists file an issue here https://github.com/pgjdbc/pgjdbc

Dave Cramer
www.postgres.rocks


On Mon, 23 Nov 2020 at 07:10, Dave, Mohit <mdave@informatica.com> wrote:

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

Вложения