UNIX_TIMESTAMP不正确的结果 - UNIX_TIMESTAMP incorrect result

UNIX_TIMESTAMP incorrect result

本文关键字：结果不正确 TIMESTAMP UNIX | 更新日期: 2023-09-27

我需要用正确的日期检查日期 + 数据库的 1 个月。我尝试：

$todayDate = date("Y-m-d");
$dateOneMonthAdded = strtotime(date("Y-m-d", strtotime($todayDate)) . "+1 month");
$result = mysql_query('SELECT UNIX_TIMESTAMP("date") AS date FROM followform WHERE id = "28"') or die(mysql_error());  
$date = mysql_fetch_assoc($result);
if ($dateOneMonthAdded == $date['date']) echo 'nice';

但是$date['日期'] == 0

如果我使用 - mysql_query('SELECT date FROM followform WHERE id = "28"')

$date['date'] == 2012-08-13

我的错误在哪里？

UNIX_TIMESTAMP("date")应该UNIX_TIMESTAMP(date) .使用引号，它试图将文字字符串"date"转换为时间戳。

从查询unix_timestamp函数中删除双引号"。它应该是：

SELECT UNIX_TIMESTAMP(date) AS date FROM followform WHERE id = "28"