MySQL 时间入库问题：Incorrect datetime value: '' for column 'createTime' at row 1_incorrect datetime value: '2023-02-30' for column

问题： 写入MySQL时  出现  Incorrect datetime value: '' for column 'createTime' at row 1

    user.setCreateTime(new Date());
    user.setExpireTime(new Date());

解决 ：

//转换时间格式
SimpleDateFormat simpleDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
user.setCreateTime(Timestamp.valueOf(simpleDate.format(new Date())));
user.setExpireTime(Timestamp.valueOf(simpleDate.format(new Date())));

有说是   mysql-connector-java 版本问题，升级就可以了，

还有url 中加入 useOldAliasMetadataBehavior=true

如

spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&characterEncoding=utf8&useUnicode=true&useOldAliasMetadataBehavior=true

Rf  :https://blog.csdn.net/helijie92902/article/details/53054199