title: Query By Last Month, Last Week, Yesterday, And So On
body: <p>I have <code>orders</code> table, which contains <code>orderID</code> &amp; <code>order_date</code>.</p>
  
  <p>I'm trying to query the data by last week, last month, or even by yesterday, however I can't figure out how to subtract time from current time</p>
  
  <p>My <code>order_date</code> field is of <code>TIMESTAMP</code> type, any idea, any help, would be appreciated</p>