Re: Decipher three lines of code

[Peter Brawley]

If j.date >= 1 day ago, j.date must be >= 15 days ago, and if either is the case then j.date > '2015-01-01' unless the server date has been hacked, so the first two clauses are superfluous. And the formatting functions are also redundant, since the format in which MySQL stores dates isn't variable.

So, it's an idiotically redundant test of whether j.date is today or later.

If j.date is a Date column, (j.date >= curdate() ) would suffice.

If j.date is Datetime, ( date(j.date) >= curdate() ) or left(j.date,10) >= curdate() would do.