Bug regarding PostgreSQL JDBC driver truncating microseconds to milliseconds

From: "Chatterjee, Ankush" <anchatterjee(at)informatica(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Bug regarding PostgreSQL JDBC driver truncating microseconds to milliseconds
Date: 2021-03-17 10:00:00
Message-ID: BYAPR03MB359149B6E0E120A75C2C0AA8C26A9@BYAPR03MB3591.namprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
We are observing that the postgresql JDBC driver is truncating microseconds data to milliseconds when writing to a table.

[cid:image001(dot)png(at)01D71B42(dot)5E1A4390]

[cid:image002(dot)png(at)01D71B42(dot)5E1A4390]

Regards,
Ankush Chatterjee | Associate Software Engineer
No 66/1, Bagmane Commerz 02, Bagmane Tech Park, CV Raman Nagar, Bangalore - 560093
Mobile: +91 9064272133
Email: anchatterjee(at)informatica(dot)com<mailto:anchatterjee(at)informatica(dot)com>
[cid:image003(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2Finformatica%3Ftrk%3Dhb_tab_compy_id_3858&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374589861&sdata=w36SKinGYQ3oXPrUzTobuRHq216uFQMm7Nf4qhXvWvE%3D&reserved=0>[cid:image005(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FInformaticaLLC&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374599855&sdata=rxAtEPPLKkcr%2FzdbfVRs6zJaE8v9HBYqzLE4PcvGXTI%3D&reserved=0>[cid:image006(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FInformatica&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374599855&sdata=MeTx%2Brgsa70rB0q9svsYf62HXyPkMTq1LBg%2FehIUvZI%3D&reserved=0>[cid:image007(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fblogs.informatica.com%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=IB7ZOrzPVaShdndyEJ3Cx%2B1DOiF84sbN2mzIfuISPPA%3D&reserved=0>[cid:image008(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplus.google.com%2Fu%2F0%2F103247695984201166817%2Fposts&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=lkN17VP0YZxqaf4E5mhu60MLETMMH7YdEUKFNF6mViw%3D&reserved=0>[cid:image009(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fblogs.informatica.com%2Ffeed%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=2%2BmzWABUFoAHinO%2BdFtVYMhsc7tQcyjqURcCbnQAJ14%3D&reserved=0>[cid:image010(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.youtube.com%2Fuser%2FInformaticaCorp&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374619845&sdata=NS6LdjJ9qWeY%2FmSWclY4WqyYeLPceTlVHcXBbMcdjeg%3D&reserved=0>

[cid:image011(dot)png(at)01D71B42(dot)5E1A4390]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.informatica.com%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374619845&sdata=eq16YVSe5EDzfzZhdzYpuzJ3yNzrtute0e5BqXf5gBE%3D&reserved=0>

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sehrope Sarkuni 2021-03-17 10:48:45 [pgjdbc/pgjdbc] 807ddb: test: Fix typo in assert message
Previous Message Jesper Pedersen 2021-03-16 18:20:33 [pgjdbc/pgjdbc] 00774d: changed: Add BEGIN/COMMIT to startup to group stat...