Debezium(Engine) always reads postgres timestamp fields as UTC

[Ankitha Kini]

We are using Debezium Engine in our Spring boot application, and our timestamp fields are in IST format. But they are being considered to be in UTC format by default, and the corresponding epoch is being sent. Can we change this behaviour?

[Chris Cranford]

Hi,

That is the default behavior out of the box.  If you want to change that behavior, you can implement a CustomConverter implementation that you deploy alongside the connector.  Another alternative would be to use a SMT in order to adjust the UTC values to whatever format you want on a per-message basis.  We are currently working on a TimestampConverter SMT that will allow you to convert these fields to a specific time zone, which might fit your needs.  Please see the upcoming pull request [1] prepared by Anisha.

Thanks,
Chris

[1]: https://github.com/debezium/debezium/pull/4781