Hi Everyone,
I have a pipeline that reads data from Postgres database and putts in to another Postgres database unchanged, I need the data to be identical, however Timestamps after being migrated missing microseconds.
2022-08-29 22:03:13.620961-05 -> Source
2022-08-29 22:03:13-05 -> Target
I have noticed that flow files contain correct format before reaching PutDatabaseRecord processor, but then on Target database microseconds are gone.
Can you please help me to understand how I can migrate timestamps with the microseconds?