关于SQL中datediff的语句 在5.0下正常 4.0就有问题了 请问如何解决！？

szgekko

$db->Query("UPDATE ".CLIENT." SET status=5 WHERE status=0 AND datediff('curdate()','add_date')>=30")
我的环境是PHP5 + MYSQL5
没问题
客户环境是PHP5 + MYSQL4
报错

MySQL Info: MySQL Query Error
Script: /test/crm/index.php
Time: 2008-01-25 03:42 pm
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('curdate()','add_date')>=30' at line 1
Errno.: #1064

Sql: UPDATE crm_client SET status=5 WHERE status=0 AND datediff('curdate()','add_date')>=30

szgekko

麻烦大家看下谢谢!

大大狗

看提示是语法有错误

大大狗

这个 datediff的用法是这样的

  DATEDIFF(expr1,expr2)[DATEDIFF(expr1,expr2)]