How to load data with date containing microseconds with yyyy-MM-dd HH:mm:ss.SSSSSS

Nabojeet — Fri, 15 Nov 2024 23:50:13 GMT

Hi Team,

We are trying to load the date from Postgress to Postgress where the date is in the format yyyy-MM-dd HH:mm:ss.SSSSSS. The issue we are facing is that it is not displaying all the 6 microsecond places and instead it's just displaying either 3 or if 6 but not as present in source.

Talend is truncating the microseconds from input to output.

Example :

Source : 2021-07-20 06:24:10.772819

Target : 2021-07-20 06:24:10.000772

We have used the inbuilt date format/pattern yyyy-MM-dd HH:mm:ss.SSSSSS in the schema.

Please suggest how to fix this .

Re: How to load data with date containing microseconds with yyyy-MM-dd HH:mm:ss.SSSSSS

Anonymous — Thu, 02 Sep 2021 07:35:20 GMT

Hello,

Please have a look at this KB article and feel free to let us know if this solution works for your case.

https://community.talend.com/s/article/How-to-fetch-data-that-uses-the-date-format-in-microseconds-yyyy-MM-dd-HH-mm-ss-SSSSSS-jIG4z

Best regards

Sabrina

topic Re: How to load data with date containing microseconds with yyyy-MM-dd HH:mm:ss.SSSSSS in Talend Studio

How to load data with date containing microseconds with yyyy-MM-dd HH:mm:ss.SSSSSS

Re: How to load data with date containing microseconds with yyyy-MM-dd HH:mm:ss.SSSSSS