# Incorrect date formatting transforms

**URL:** <https://forum.confluent.io/t/incorrect-date-formatting-transforms/8093>\
**Category:** Kafka Connect\
**Created:** [14 June 2023 08:35 UTC](https://forum.confluent.io/t/incorrect-date-formatting-transforms/8093 "2023-06-14T08:35:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abdugani](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@Abdugani](https://forum.confluent.io/u/Abdugani)\
**Post date:** [14 June 2023 08:35 UTC](https://forum.confluent.io/t/incorrect-date-formatting-transforms/8093/1 "2023-06-14T08:35:36Z")

</div>

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

```auto
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?

---

<div class="post-metadata">

**Author:** ![OneCricketeer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/onecricketeer/32/1551_2.png) [@OneCricketeer](https://forum.confluent.io/u/OneCricketeer)\
**Post date:** [23 June 2023 03:33 UTC](https://forum.confluent.io/t/incorrect-date-formatting-transforms/8093/2 "2023-06-23T03:33:56Z")

</div>

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**

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [23 July 2023 03:34 UTC](https://forum.confluent.io/t/incorrect-date-formatting-transforms/8093/3 "2023-07-23T03:34:35Z")

</div>

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