Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. TO_DAYS(date) returns a day number (the number of days since year 0)
mysql>
mysql> SELECT TO_DAYS(950501);
+-----------------+
| TO_DAYS(950501) |
+-----------------+
|          728779 |
+-----------------+
1 row in set (0.00 sec)
mysql>