MySQL DATEDIFF行为不一致 [英] Inconsistent MySQL DATEDIFF behavior

问题描述

当我使用此查询时：

SELECT COUNT(*) FROM `my_table` WHERE DATEDIFF(NOW(), updated) > 2

MySQL执行查询时没有错误，我得到了未更新的行数最近2天。但是，如果我这样更改查询：

MySQL executes the query with no errors and I get the count of rows that have not been updated within the last 2 days. However, if I change the query like this:

SELECT * FROM `my_table` WHERE DATEDIFF(NOW(), updated) > 2

我收到以下错误：

#1305 - FUNCTION mydatabase.DATEDIFF does not exist

任何想法为什么会这样？

Any ideas why this is so?

推荐答案

我也遇到过类似的问题，如果未设置，它将无法在SELECT上运行

I've had a similar problem where it would not work on SELECT if I had not set the LIMIT.

尝试执行以下操作：

SELECT * FROM `my_table` WHERE DATEDIFF(NOW(), updated) > 2 LIMIT 0, 10

它在MySQL更新中得到纠正。尝试也更新您的MySQL版本。

It got corrected on a MySQL update. Try to update your MySQL version also.

这篇关于MySQL DATEDIFF行为不一致的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！