<p>How to create a table with a timestamp column that defaults 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.</p>

As of
version 3.1.0
you can use
```
CURRENT_TIMESTAMP
```
with the
DEFAULT
clause:
If the default value of a column is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the value used in the new row is a text representation of the current UTC date and/or time. For CURRENT_TIME, the format of the value is "HH:MM:SS". For CURRENT_DATE, "YYYY-MM-DD". The format for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".
```
```
CREATE TABLE test (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    t TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
```
```