dinky icon indicating copy to clipboard operation
dinky copied to clipboard

Invalid timestamp Format

Open ljs033 opened this issue 1 year ago • 5 comments

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

ljs033 avatar Jul 18 '24 00:07 ljs033

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

QianQiu0923 avatar Jul 18 '24 09:07 QianQiu0923

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

试过了

ljs033 avatar Jul 19 '24 00:07 ljs033

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

ljs033 avatar Jul 20 '24 02:07 ljs033

@github-actions

ljs033 avatar Jul 22 '24 13:07 ljs033

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 天后将关闭,如需回复,可以评论回复。

github-actions[bot] avatar Sep 01 '24 00:09 github-actions[bot]