title: SQL - Find date closest to current date
body: <p>I'm having some trouble with my SQL query.
  I got this table: </p>
  
  <pre><code>insert into Table1 (date, personssn)
  insert ('2012-01-21 12:01:33', '123456789');
  insert into Table1 (date, personssn)
  insert ('2012-02-22 12:01:33', '123456789');
  </code></pre>
  
  <p>The problem is that I want to select the personssn who have a date CLOSEST to the current date. I've been working with "CURDATE()" but can't seem to get it to work. Anyone that can help me in the right direction?</p>
  
  <p>Thanks.</p>