Incorrect date formatting transforms

Kafka Connect
1

Hello. I am using io.confluent.connect.jdbc.JdbcSinkConnector to migrate data
when using format yyyy-MM-dd’T’HH:mm:ss.SSSZ i get wrong data 54522-09-23 03:38:59.000000 but it should be 2022-07-21 11:44:22.739000

transforms.CreatedConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value
transforms.CreatedConverter.format=yyyy-MM-dd'T'HH:mm:ss.SSSZ
transforms.CreatedConverter.field=created_at
transforms.CreatedConverter.target.type=Timestamp

How to fix it?

2

Wrong, in what way? There are unit tests for this class.

For example, are you trying to convert nano/microseconds, when the documentation says it’ll only convert Unix epoch which is represented in seconds

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.