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 2022/10/09 06:19:33 UTC
[GitHub] [shardingsphere] Spackys opened a new issue, #21416: about timezone has no effect
Spackys opened a new issue, #21416:
URL: https://github.com/apache/shardingsphere/issues/21416
When I use a jdbc-url with serverTimezone=Asia/Shanghai or serverTimezone=GMT%2B8, There is no effect. When insert date to mysql database is still UTC timezone, also mysql timezone is set to '+08:00'. For example, now is 14:13, use code the date is correct, but database date is 6:13.Directly use other tools connect database is normal with this jdbc-url setting.How can I set to correct the timezone? Thanks!
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] byteboycn commented on issue #21416: about timezone has no effect
Posted by "byteboycn (via GitHub)" <gi...@apache.org>.
byteboycn commented on issue #21416:
URL: https://github.com/apache/shardingsphere/issues/21416#issuecomment-1427467330
I have same problem with using ShardingSphere-Proxy v5.3.1
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #21416: about timezone has no effect
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21416:
URL: https://github.com/apache/shardingsphere/issues/21416#issuecomment-1407416813
The following information cannot be obtained from the issue description:
- Are you using ShardingSphere-JDBC or ShardingSphere-Proxy?
- What version are you using?
Please follow the issue template to submit information in order to get help, thank you.
---
Considering this issue has been around for a long time, I'm closing it now. If you still have the same problem, please reopen it or submit a new one
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #21416: about timezone has no effect
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21416:
URL: https://github.com/apache/shardingsphere/issues/21416#issuecomment-1428025117
@byteboycn
When using ShardingSphere-Proxy, both the url that the client connects to the Proxy and the url that the Proxy connects to dataSources need to set parameters, please try it.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #21416: about timezone has no effect
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21416: about timezone has no effect
URL: https://github.com/apache/shardingsphere/issues/21416
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org