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

[Nabojeet]

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 .

[Anonymous]

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-y...

Best regards

Sabrina