Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
None
-
None
-
None
-
False
-
None
-
False
Description
From Google Translate:
I find that the converted timestamp seems to be a time zone issue
Hope to get help, thank you
What Debezium connector do you use and what version?
1.9.5.final
What is the connector configuration?
cdc config:
{
"name":"test-cdc",
"config":
}
What is the captured database version and mode of depoyment?
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
----------------------------------------
docker run d --name debezium-connect -p 8083:8083 -e GROUP_ID=1 -e CONFIG_STORAGE_TOPIC=debezium-connect-configs -e OFFSET_STORAGE_TOPIC=debezium-connect-offsets -e STATUS_STORAGE_TOPIC=debezium-connect-statuses -e ADVERTISED_HOST_NAME=$(echo $DOCKER_HOST | cut -f3 -d'/' | cut -f1 -d':') -e BOOTSTRAP_SERVERS=ip:port -e KAFKA_CONNECT_PLUGINS_DIR=/kafka/connect/ -privileged=true -v /debezium/kafka/connect/:/kafka/connect/ debezium/connect-base:1.9.5.Final
----------------------------------------------
What behaviour do you see?
timezone in sqlserver:
SELECT SYSDATETIMEOFFSET();
2022-08-12 15:37:21.8788422+8
or
DECLARE @TimeZone VARCHAR(50)
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',
'TimeZoneKeyName',@TimeZone OUT
SELECT @TimeZone
China Standard Time
---------------------------------------
createTime = 2021-12-30 10:35:41.000 in sqlserver
createTime = 1640860541000 in debezium
The timestamp is 8 hours longer than the time in sqlsever