在PHP中：
$days = (strtotime($date) - time()) / 86400;
在MySQL中：
SELECt ((UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP()) / 86400) AS daysFROM table;
或如@coreyward所述（在MySQL中）：
SELECt DATEDIFF(UNIX_TIMESTAMP(date,NOW()) AS daysFROM table;
在PHP中：
$days = (strtotime($date) - time()) / 86400;
在MySQL中：
SELECt ((UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP()) / 86400) AS daysFROM table;
或如@coreyward所述（在MySQL中）：
SELECt DATEDIFF(UNIX_TIMESTAMP(date,NOW()) AS daysFROM table;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
