如何解析0000-00-00 00:00:00？

Question

我正在解析MySQL数据库中的一些时间值，其中一些值为零。为什么Go不能解析它，我如何修复它？

checkTime := "0000-00-00 00:00:00"
t, err := time.Parse("2006-01-02 15:04:05", checkTime)
if err !=nil{
    log.Errorf("err %v, checkTime %v, ID %v", err, checkTime, bk.ID)
}

得到这个：

err parsing time "0000-00-00 00:00:00": month out of range, checkin 0000-00-00 00:00:00

Answer 1

That does not parse because there was no year zero. After 1 B.C. is 1 A.D.

With most contexts, it probably makes sense to make a special check for year zero and store a NULL value in its place.

---

From a practical viewpoint, any dates given as being in a year between 1 AD and around 600 A.D. are poorly documented and likely wrong. Somewhere in there are a few missed years. Academics aren't sure how many, but they mostly agree that at least 4 years are missing and maybe as many as 8 or 10. That is, the year 2015 actually should be 2019 to 2029.