MySQL限于TIMESTAMP范围的解决方法? [英] Workaround for MySQL limited TIMESTAMP range?
本文介绍了MySQL限于TIMESTAMP范围的解决方法?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有人知道在MySQL TIMESTAMP字段中存储UTC范围从'1970-01-01 00:00:01'UTC到'2038-01-09 03:14:07'UTC之外的值的解决方法吗?/p>
Does anyone know of a workaround for storing values outside of the range '1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07' UTC in a MySQL TIMESTAMP field?
推荐答案
如果将列更改为使用DATETIME类型,则可以存储更大范围的值.
If you alter the column to use the DATETIME type, you can store a wider range of values.
TIMESTAMP类型的范围是UTC到'1970-01-01 00:00:01'UTC到'2038-01-09 03:14:07'UTC.
the TIMESTAMP type's range is '1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07' UTC.
DATETIME类型的范围是"1000-01-01 00:00:00"到"9999-12-31 23:59:59".
the DATETIME type's range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
这篇关于MySQL限于TIMESTAMP范围的解决方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文