title: Get current date in cassandra cql select
body: <p>In SQL, I am able to do:</p>
  
  <pre><code>select getdate(), getdate() - 7
  </code></pre>
  
  <p>Which returns the current date as well as current date - 7 days. I want to achieve the same in Cassandra CQL. I tried:</p>
  
  <pre><code>select dateof(now())
  </code></pre>
  
  <p>But that does not work. It works only on insert and not in select. How can I get the same? Any help would be appreciated.</p>