title: What is the equivalent of ORACLE's SYSDATE in Impala?
body: <p>I have a WHERE clause I am trying to convert from ORACLE SQL into Impala SQL. The col2 output looks something like 201406. I need to have this readable for Impala then format it then turn it into a string. Any help would be much appreciated!</p>
  
  <pre><code>WHERE Table1.col2 &lt;= to_char( SYSDATE-7, 'YYYYMM')
  </code></pre>