TO_DAYS(date) 給定一個日期，返回一個天數(年為0以來的天數)。 ~~~ mysql> SELECT TO_DAYS(950501); +---------------------------------------------------------+ | TO_DAYS(950501) | +---------------------------------------------------------+ | 728779 | +---------------------------------------------------------+ 1 row in set (0.00 sec) ~~~ ~~~ mysql> SELECT TO_DAYS('2009-05-18'); +-----------------------+ | TO_DAYS('2009-05-18') | +-----------------------+ | 733910 | +-----------------------+ 1 row in set (0.03 sec) ~~~ 查詢今天的數據： ~~~ SELECT * FROM 表名 WHERE TO_DAYS(日期時間字段名) = TO_DAYS(now()); ~~~ * * * * * [TO_DAYS](https://www.w3resource.com/mysql/date-and-time-functions/mysql-to_days-function.php) #### TO_DAYS(date) 返回日期date是西元0年至今多少天(不計算1582年以前) ~~~ mysql> select TO_DAYS(950501); 　　-> 728779 mysql> select TO_DAYS('1997-10-07'); 　　-> 729669 ~~~