Hi all, I have a question regarding Postgres to S...
# ask-community-for-troubleshooting
a
Hi all, I have a question regarding Postgres to S3 connection as JSONL. I'm facing an issue where the postgres timestamp fields are not coming to S3 with the same precision. It's taking only upto seconds and ignoring the microseconds that's in the system. Is there any way to fix this?
Sample data ...
created_at
and `updated_at`fields are
timestamptz
fields in the database
Copy code
"_airbyte_data": {
    "id": "xxxx-xxxx-xxxx-xxxx-xxxxxxxxxx",
    "event": "xxxxxxxx", 
    "status": "xxxxxx",
    "active": false,
    "created_at": "2021-09-06T15:51:56Z",
    "updated_at": "2021-10-11T20:11:12Z"
  },