MySQL DATEDIFF行为不一致 [英] Inconsistent MySQL DATEDIFF behavior
本文介绍了MySQL DATEDIFF行为不一致的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我使用此查询时:
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屋!
查看全文