Jump to content

Archived

This topic is now archived and is closed to further replies.

qugh

DateDiff Question

Recommended Posts

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

Share this post


Link to post
Share on other sites

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--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.