title: Amazon Redshift : Best way to compare dates
body: <p>I have a sample table in redshift. I want to generate a report with the month wise data. I found the below three ways so far.</p>
  <ol>
  <li><p><code>trunc(created_at_date) between '2014-06-01' and '2014-06-30'</code></p>
  </li>
  <li><p><code>created_at_date like '2014-06%'</code></p>
  </li>
  <li><p><code>created_at_date &gt;= '2014-06-01 00:00:00' and created_at_date &lt;= '2014-06-30 23:59:59'</code></p>
  <p>What is the best and optimal way to do so?</p>
  </li>
  </ol>