java mysql 时间不对_Java中日期时间和Mysql的日期不一致

问题说明

Java代码中获取当前日期正确，存如数据库时间不一致

Java代码

注意：添加了 Locale.CHINA

public static Date getNowDate(){

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.CHINA);

Date date = new Date(System.currentTimeMillis());

String format = formatter.format(date);

return stringFormatDateLong(format);

}

application.yaml配置

datasource:

type: com.alibaba.druid.pool.DruidDataSource

driver-class-name: com.mysql.cj.jdbc.Driver

url: jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

username: root

password: 0000

问题解决

添加url参数 &allowMultiQueries=true

datasource:

type: com.alibaba.druid.pool.DruidDataSource

driver-class-name: com.mysql.cj.jdbc.Driver

url: jdbc:mysql://47.96.102.131:3306/demo?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&serverTimezone=CTT

username: root

password: 0000