MySQL - Get next closest day between two days <p>We have two dates in database:</p> <ol> <li>2013-08-01</li> <li>2013-08-03</li> </ol> <p>Let say that today's date is 2013-08-02 and we want to get next closest date from database. I've found this query, but it's not getting the next day but previous:</p> <pre><code>SELECT * FROM your_table ORDER BY ABS(DATEDIFF(NOW(), `date`)) LIMIT 1 </code></pre> <p>When we run it, we get 2013-08-01 and not 2013-08-03 as we want. What would be the solution?</p>