Jump to content


Photo

DateDiff Question


  • Please log in to reply
1 reply to this topic

#1 qugh

qugh
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 07 November 2005 - 10:48 PM

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

#2 Cook

Cook
  • Members
  • PipPipPip
  • Advanced Member
  • 64 posts
  • LocationSingapore

Posted 08 November 2005 - 12:08 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users