title: sqlite database default time value 'now'
body: <p>Is it possible in a sqlite database to craete a table that has a timestamp column that default to <code>DATETIME('now')</code> ?</p>
  
  <p>Like this:</p>
  
  <pre><code>CREATE TABLE test (
      id INTEGER PRIMARY KEY AUTOINCREMENT, 
      t TIMESTAMP DEFAULT DATETIME('now')
  );
  </code></pre>
  
  <p>This gives an error... How to resolve?</p>