title: How to subtract 30 days from the current datetime in mysql?
body: <p>How do I subtract 30 days from the current datetime in mysql?</p>
  
  <pre><code>SELECT * FROM table
  WHERE exec_datetime BETWEEN DATEDIFF(NOW() - 30 days) AND NOW();
  </code></pre>