************ 一条MYSQL 语句不知道哪里错了 **********

[Xiaomillet]

判断数据是否提交！！！！

select  count(*) from worklog where userid=@userid and DATEDIFF('d', addDate, Now())=0

error：Error Code : 1064
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 '?userid and DATEDIFF('d', addDate, Now())=0' at line 1
(16 ms taken)


userid and DATEDIFF('d', addDate, Now())=0' at line 1 这里哪里错了呢？？？

[丰云]

select count(*) from worklog where userid=@userid and DATEDIFF(addDate, Now())=0

[子夜__]

mysql中datediff函数只有2个参数么？

DATEDIFF(expr ,expr2 )

[Lisliefor]

MySQL DATEDIFF() 函数


mysql里的datediff()函数只有两个参数，并且只返回日期部分的差值。

[Xiaomillet]

楼上的都是正解，MYSQL 的 datediff（） 只有两个参数，但是oracle的就有三个