title: Query WHERE date is more recent than 14 days
body: <p>I'm trying to find a way to do a request in MySQL such as this one :</p>
  
  <pre><code>SELECT * FROM table WHERE insert_date &lt; '14 days'
  </code></pre>
  
  <p>From googling, I found two answers :</p>
  
  <pre><code>SELECT * FROM table WHERE insert_date &lt; DateAdd(dd,-14,GetDate())
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * FROM table WHERE insert_date &lt; DateAdd(day,Datediff(day,0,getdate()),-14)
  </code></pre>
  
  <p>So here are my questions : </p>
  
  <p>1) Are there better ways to do this ?</p>
  
  <p>2) What is the difference between the two things I found ?</p>
  
  <p>Thanks</p>