|
mysql>
mysql> select TO_DAYS('2000-01-01') ;
+-----------------------+
| TO_DAYS('2000-01-01') |
+-----------------------+
| 730485 |
+-----------------------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql> SELECT FROM_DAYS(1000000);
+--------------------+
| FROM_DAYS(1000000) |
+--------------------+
| 2737-11-28 |
+--------------------+
1 row in set (0.02 sec)
mysql>
|