在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;
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)