MySql 数据表中数据时间字段差8小时
1 问题
java应用程序写入MySQL的数据时间字段小8小时
2 查看MySQL服务器时区配置
mysql> show variables like '%time_zone';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CST |
| time_zone | SYSTEM |
+------------------+--------+
mysql> select now(), curtime();
+---------------------+-----------+
| now() | curtime() |
+---------------------+-----------+
| 2024-10-17 16:32:33 | 16:32:33 |
+---------------------+-----------+
1 row in set (0.00 sec)
3 修改java应用连接mysql的url
添加serverTimezone=Asia/Shanghai,比如jdbc连接如下:
jdbc:mysql://localhost:3306/db_name?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
原文地址:https://blog.csdn.net/xutfng/article/details/143022092
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!