Re: Can datediff be used?

[Anthony Willard]

Editorial aside, I don't know if DATEDIFF is a good answer as it returns a number, not true or false.

If you were to look at every date and look for the "next" date in sequence, you could join on that. It's not DATEDIFF, but DATE_ADD().

SELECT a.*
FROM mytable a
LEFT OUTER JOIN mytable b ON b.mydate = DATE_ADD( a.mydate, INTERVAL 1 DAY )
WHERE b.mydate IS NULL

This might still respect indexes and perform well.

Give that a try.

Anthony