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. +-----------------------+

keyword

  1. TO_DAYS,TO,DAYS