java.sql.BatchUpdateException: Date truncation: Out of range value for column xxxxx

报错:

java.sql.BatchUpdateException: Date truncation: Out of range value for column xxxxx

原因:
xxx 列 ddl 中为 stock_num(12,2)

数据库值为0.06
需要更新为：0.06 - 0.21

就会出现该错误

参考：

https://www.jb51.net/article/158166.htm
https://blog.csdn.net/stone_tomcate/article/details/103470241