title: SQLite storing default timestamp as unixepoch
body: <p>When defining a relation, I want to update an attribute to the timestamp at insert. For example, a working table that I have right now</p>
  
  <pre><code>CREATE TABLE t1(
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  time TIMESTAMP
  DEFAULT CURRENT_TIMESTAMP,
  txt TEXT);
  </code></pre>
  
  <p>This is updating a timestamp on insert, for example, <code>insert into t1 (txt) values ('hello')</code> adds the row <code>1|2012-07-19 08:07:20|hello|</code>. However, I want to have this date formatted in unixepoch format. </p>
  
  <p>I read the <a href="http://www.sqlite.org/lang_datefunc.html" rel="noreferrer">docs</a> but this wasn't clear. For example, I modified the table relation to <code>time TIMESTAMP DEFAULT DATETIME('now','unixepoch')</code> but I get an error. Here, as in the docs, <code>now</code> was my time string and <code>unixepoch</code> was the modifier but it didn't work. Could someone help me how to format it as a unixepoch timestamp?</p>