DateDiff Question

[qugh]

My question is about the 'datediff' function. I am trying to select all dates from today or after, but I'm getting an error with this statement at the DateDiff function. Here's my query as is.

 

SELECT *

 

FROM

data_events as d

 

WHERE

Deleted = 0

AND

DATEDIFF( d.sDate , Now() ) >= 0

 

ORDER BY

sDate

 

LIMIT 5

[Cook]

If what you're after is all dates later than (or equal to) now, this is a simpler way of doing it:

 

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM `data_events` AS `d` WHERE `[span style=\'color:blue;font-weight:bold\']Delete[/span]d` = 0 AND `d`.`sDate`>= NOW() ORDER BY `sDate` LIMIT 5 [!--sql2--][/div][!--sql3--]