debezium-timestamp-converter icon indicating copy to clipboard operation
debezium-timestamp-converter copied to clipboard

Published 20 hours ago • verified publisher icon oryanmoshe

Date and Time prevision issue on Sql Server

Open terryfkjc opened this issue 2 years ago • 0 comments

Hi,

I have the follow table in my source database (MS SQL 2019). Precisions are lost for the following data type:

data type value in database converted value
datetime2(6) 2022-04-01 11:11:42.929775 2022-04-01 11:11:42.0000929
datetime2(7) 2022-04-01 11:11:42.9297751 2022-04-01 11:11:42.0000929
time(3) 11:11:42.930 11:11:42.0000000
time(6) 11:11:42.929775 11:11:42.0000000
time(7) 11:11:42.9297751 11:11:42.0000000

And here are my configurations

"converters": "timestampConverter",
"timestampConverter.type": "oryanmoshe.kafka.connect.util.TimestampConverter",
"timestampConverter.format.time": "HH:mm:ss.SSSSSSS",
"timestampConverter.format.date": "YYYY-MM-dd",
"timestampConverter.format.datetime": "YYYY-MM-dd HH:mm:ss.SSSSSSS"

Any idea?

terryfkjc avatar Apr 01 '22 11:04 terryfkjc