You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/09/24 11:20:42 UTC
[GitHub] [incubator-shardingsphere] Myshiner opened a new issue #3105: Got 8
hours offset due to the serverTimezone setting in sharding-proxy is
different from the mysql server timezone
Myshiner opened a new issue #3105: Got 8 hours offset due to the serverTimezone setting in sharding-proxy is different from the mysql server timezone
URL: https://github.com/apache/incubator-shardingsphere/issues/3105
project: sharding-proxy
version: v3.1.0
question:
The serverTimezone is set to UTC in sharding-proxy, and the variable system_time_zone is set to CST and time_zone is SYSTEM in mysql server, i have a table which include a timestamp column by default value current_timestamp, when i insert a value by default from sharing-proxy, i got the value is 8 hours offset. But this case didn't appear inevitably.
example:
table structure: create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
the sharding-proxy serverTimezone:
url: jdbc:mysql://10.10.0.193:4306/neworiental_user?serverTimezone=UTC&useSSL=false
the timezone in mysql server:
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services