TO_DAYS(date) returns a day number (the number of days since year 0). : TO_DAYS « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TO_DAYS
mysql>
mysql> SELECT TO_DAYS(950501);
+-----------------+
| TO_DAYS(950501) |
+-----------------+
|          728779 |
+-----------------+
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