TO_DAYS

声明

TO_DAYS(date)

说明

返回指定 date 值对应的天数。天数指距离 0000-01-01 的天数。

示例

SELECT TO_DAYS('2015-11-04'), TO_DAYS('20151104');
+-----------------------+---------------------+
| TO_DAYS('2015-11-04') | TO_DAYS('20151104') |
+-----------------------+---------------------+
|                736271 |              736271 |
+-----------------------+---------------------+
1 row in set (0.001 sec)