一、查询数据库统默认时区
二、查看数据库连接用的时区
?useUnicode=true&characterEncoding=UTF-8&serverTimezone=AUTC&useSSL=false
修改
?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
补充JAVA日期转换:
public String dateToString(Date openTime){
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd kk:mm:ss ");
sdf.setTimeZone(TimeZone.getTimeZone("Asia/Shanghai"));
return sdf.format(openTime);
}