1、to_days(date), change the date to a integer number days.
mysql> SELECT TO_DAYS(950501); -> 728779
mysql> SELECT TO_DAYS('1997-10-07'); -> 729669
2、from_days(number), change the integer number days to a date.
mysql> SELECT FROM_DAYS(729669); -> '1997-10-07'