douzhi7070
2019-01-08 09:00
浏览 767

将Go的零time.Time值插入MySQL DATETIME列错误

The zero time.Time value generated by Go throws an error when it is inserted into MySQL DATETIME column.

Error that I get: Error 1292: Incorrect datetime value: '0000-00-00' for column 'expires_at' at row 1

However, when I increment this time.Time value just by 1 nanosecond or change the year to at least 2, it gets inserted without any error.

Does this mean that I cannot insert Go generated zero time.Time values into MySQL DATETIME column?

I'm using package sql's Exec to perform the INSERT. I pass the time.Time value as argument to Exec().

sess.Exec(stmt, valueArgs...)

图片转代码服务由CSDN问答提供 功能建议

Go 生成的零 time.Time 值引发 将其插入MySQL DATETIME 列时发生错误。

我得到的错误:错误1292:日期时间值不正确:'0000-00-00 '代表第1行的'expires_at'列

但是,当我将此 time.Time 值仅增加1纳秒或将年份更改为 至少2,它将被正确插入。

这意味着我无法将Go生成的零 time.Time 值插入MySQL DATETIME < / code>列?

我正在使用包sql Exec 执行 INSERT 。 我将 time.Time 值作为参数传递给 Exec()

sess.Exec(stmt,valueArgs。 ..)

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douye2488 2019-01-08 09:04
    已采纳

    Because MySQL DATETIME valid range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. All zero is out of range.

    The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

    Source

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题