title: mysql select closest date from today
body: <p>I have below table</p>
  
  <pre><code>    date
  -----------------------
  1. 2017-01-02 20:59:00
  2. 2017-01-04 10:00:00
  3. 2017-01-04 11:00:00
  4. 2017-01-09 17:20:00
  </code></pre>
  
  <p>Q1: Assuming today is <code>2017-01-03</code>, how can i select the above date to get the result of 2 and 3 ?  </p>
  
  <p>Q2: assume today is <code>2017-01-05</code>, get the result of 4 ?</p>