# Kafka Timestamp Transforms

**URL:** <https://forum.confluent.io/t/kafka-timestamp-transforms/11134>\
**Category:** Self-Managed Connectors\
**Created:** [29 July 2024 01:39 UTC](https://forum.confluent.io/t/kafka-timestamp-transforms/11134 "2024-07-29T01:39:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheekamadu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/cheekamadu/32/3912_2.png) [@cheekamadu](https://forum.confluent.io/u/cheekamadu)\
**Post date:** [29 July 2024 01:39 UTC](https://forum.confluent.io/t/kafka-timestamp-transforms/11134/1 "2024-07-29T01:39:39Z")

</div>

Hello,

I have noticed a weird behaviour with the timestamp transform (org.apache.kafka.connect.transforms.TimestampConverter$Value) while using the JDBC sink connector. We have some date column being read from spanner, and is stored to the kafka topic as a string in this format:

“created\_on”: {  
“string”: “2024-07-29T01:18:07.845031299Z”  
},

We then apply the transform to this field, to write to a Mysql DB as the target, as captured below:

“”"  
transforms.convertcreated.type=org.apache.kafka.connect.transforms.TimestampConverter$Value  
transforms.convertcreated.field=created\_on  
transforms.convertcreated.format=yyyy-MM-dd’T’HH:mm:ss.SSS’Z’  
transforms.convertcreated.target.type=Timestamp  
“”"

When the data does get written, it shows up as a future date: 2024-08-07T20:01:58

We are having difficulties understanding what the issue is. Furthermore, even if we change the column to a string type, and also change the transform’s target.type to a string, it still returns the wrong date: 2024-08-07T20:01:58.299Z.

The only time we have no issues is when we do not apply a transform, but set the DB column to a string type.

Any help would be greatly appreciated.