title: MySQL get the date n days ago as a timestamp
body: <p>In MySQL, how would I get a timestamp from, say 30 days ago?</p>
  
  <p>Something like:</p>
  
  <pre><code>select now() - 30
  </code></pre>
  
  <p>The result should return a timestamp.</p>