Defaulting to now for date

It can be useful to have dates default to now when inserting records.

CREATE TABLE test (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  t TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

References

• ‘StackOverflow’