to_days

description

Syntax

INT TO_DAYS(DATETIME date)

返回date距离0000-01-01的天数

参数为Date或者Datetime类型

example

1. mysql> select to_days('2007-10-07');
2. +-----------------------+
3. | to_days('2007-10-07') |
4. +-----------------------+
5. |                733321 |
6. +-----------------------+

keywords

1. TO_DAYS,TO,DAYS