1970年之前的时间戳保存为0000-00-00 00:00:00

Question

I have a timestamp column corresponding to model property. But when I try to save a timestamp before 1970 in the table appears the value of 0000-00-00 00:00:00.

Am I not using the appropriate format? Is date more suitable? Is there a workaround so I don't need to change my schema?

Answer 1

The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z).

If you're planning on using times that fall previous to that date, I recommend using a date field.