sqlite database default time value 'now'

Question

Is it possible in a SQLite database to create a table that has a timestamp column that defaults to DATETIME('now')?

Like this:

CREATE TABLE test (

    id INTEGER PRIMARY KEY AUTOINCREMENT, 

    t TIMESTAMP DEFAULT DATETIME('now')

);

This gives an error... How to resolve?

Answer 1

Try the code given below:

CREATE TABLE test (

  id INTEGER PRIMARY KEY AUTOINCREMENT,

  t TIMESTAMP

  DEFAULT CURRENT_TIMESTAMP

);