PHP和MySQL能够识别的最大日期是多少?
我的意思是,我有不同时间轴的不同值,并且我想使它们都成为MySQL中的BETWEEN
选择,像这样:
SELECT * FROM table WHERE date BETWEEN '2011-10-01' AND '2011-10-02';
SELECT * FROM table WHERE date BETWEEN '2011-10-03' AND '2011-10-10';
为了获取所有选项,我在考虑像这样的方式: 等等。
SELECT * FROM table WHERE date BETWEEN '0000-01-01' AND '2011-10-01';
SELECT * FROM table WHERE date BETWEEN '2011-10-02' AND '2011-10-10';
SELECT * FROM table WHERE date BETWEEN '2011-10-11' AND '9999-12-31';
这个代码会一直有效吗?还是存在某些可能导致代码出错的风险?
1970-01-01
到2038-01-19
吗? - Peon