title: How to perform a BETWEEN operator in Hive SQL for date column
body: <p>I'll try to explain my problem as clear as possible. I would like to filter a table by date (selecting only the record have the date included in <strong>current month</strong>) and in Oracle SQL I'm using the following query to achieve such goal:</p>
  
  <pre><code>select * from table t1 
  where t1.DATE_COLUMN between TRUNC(SYSDATE, 'mm') and SYSDATE
  </code></pre>
  
  <p>How can I replicate the same filter in Hive SQL? The column I should use to apply the filter is a <strong>TIMESTAMP</strong> type column (e.g. <em>2017-05-15 00:00:00</em>). </p>
  
  <p>I'm using CDH 5.7.6-1.</p>
  
  <p>Any advice? </p>