title: How to create a datetime column with default value in sqlite3?
body: <p>Is there a way to create a table in sqlite3 that has a datetime column that defaults to 'now'?</p>
  
  <p>The following statement returns a syntax error:</p>
  
  <pre><code>create table tbl1(id int primary key, dt datetime default datetime('now'));
  </code></pre>
  
  <p><strong>Update</strong>: Here's the correct ddl courtesy of <a href="https://stackoverflow.com/users/242897/sky-sanders">Sky Sanders</a>:</p>
  
  <pre><code>create table tbl1(id int primary key, dt datetime default current_timestamp);
  </code></pre>