title: sqlite get current date as integer yyyyMMdd
body: <p>is there any way to get the current date as an integer, in format yyyyMMdd ?</p>
  
  <p>Already tried :</p>
  
  <pre><code>select date ('now')
  </code></pre>
  
  <p>But the result is 2015-06-12</p>
  
  <p>Thanks!</p>