ZBLOG

gorm Error 1292: Incorrect datetime value: '0000-00-00' for column 'modify_time' at row 11438

This error occurs when you are trying to insert or update a record in a MySQL database and the value you are providing for the “modify_time” column is not a valid date/time value. Specifically, it appears that you are trying to set the “modify_time” column to ‘0000-00-00’, which is not a valid date/time value in MySQL.

To resolve this issue, you will need to update your code or data so that you are providing valid date/time values for the “modify_time” column. This may involve checking your input data or modifying your database schema to allow for null values or other default values if necessary.

It is important to note that using ‘0000-00-00’ as a placeholder for dates can cause issues with sorting and querying data. It is recommended to use NULL instead of ‘0000-00-00’ in such cases.

本站部分文章来源于网络,版权归原作者所有,如有侵权请联系站长删除。
转载请注明出处:https://golang.0voice.com/?id=5890

分享:
扫描分享到社交APP
上一篇
下一篇
发表列表
游客 游客
此处应有掌声~
评论列表

还没有评论,快来说点什么吧~

联系我们

在线咨询: 点击这里给我发消息

微信号:3007537140

上班时间: 10:30-22:30

关注我们
x

注册

已经有帐号?