Invalid timestamp Format

ljs033 commented 3 months ago

Search before asking

[X] I had searched in the issues and found no similar issues.

What happened

微信截图_20240718085543 使用了日期转换器，date类型格式可以转换，但是timestamp类型格式没有转换

What you expected to happen

在整库同步 'sink.connector'='datastream-kafka' 添加如下代码段 'debezium.converters'='dinkyDateConverter', 'debezium.dinkyDateConverter.type'='org.dinky.cdc.debezium.converter.OracleDebeziumConverter', 'debezium.dinkyDateConverter.database.type'='oracle', 'debezium.dinkyDateConverter.format.date'='yyyy-MM-dd', 'debezium.dinkyDateConverter.format.timestamp'='yyyy-MM-dd HH:mm:ss.SSS', 'debezium.dinkyDateConverter.format.timestamp.zone' = 'Asia/Shanghai'

How to reproduce

timestamp日期类型能转成'yyyy-MM-dd HH:mm:ss.SSS'的形式

Anything else

No response

Version

dev

Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct

QianQiu0923 commented 3 months ago

@ljs033 Have you tried the parameter 'debezium.dinkyDateConverter.format.datetime'='yyyy-MM-dd HH:mm:ss.SSS'?

ljs033 commented 3 months ago

@QianQiu0923 Have you tried the parameter 'debezium.dinkyDateConverter.format.datetime'='yyyy-MM-dd HH:mm:ss.SSS'?

试过了

ljs033 commented 3 months ago

@QianQiu0923 微信图片_20240720102334 使用connector=kafka 或者 connector=upsert-kafka 搭配日期转换器，会出现以上错误

ljs033 commented 3 months ago

@github-actions

github-actions[bot] commented 2 months ago

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。

DataLinkDC / dinky