title: Get last month data from first day until last day in Firebird
body: <p>I am trying to query Firebird to get data from last month, from day 1 until last day (30 or 31 depending on the month). When I use the code below it gives me shifted dates from current, for example day 11/14/2017 until 12/13/2017.</p>
  
  <p>The code:</p>
  
  <pre><code>WHERE DATE &gt;= DATEADD(MONTH,-1, CURRENT_TIMESTAMP(2)) AND DATE&lt;= 'TODAY'
  </code></pre>
  
  <p>The desired output is 11/01/2017 - 11/30/2017</p>
  
  <p>What is the correct way to do it?</p>