SELECT TO_DAYS('1997-10-07'); : TO_DAYS « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TO_DAYS
mysql>
mysql> SELECT TO_DAYS('1997-10-07');
+-----------------------+
| TO_DAYS('1997-10-07') |
+-----------------------+
|                729669 |
+-----------------------+
1 row in set (0.00 sec)

mysql>








14.50.TO_DAYS
14.50.1.TO_DAYS(date) returns a day number (the number of days since year 0).
14.50.2.SELECT TO_DAYS('1997-10-07');
14.50.3.Deal with two-digit-year value