How to create timestamp column with default value ‘now’?

by

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
);

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. SQLite Reset Primary Key Field
  5. How do I dump the data of some SQLite3 tables?
  6. SQLite – How do you join tables from different databases?
  7. Declare variable in SQLite and use it
  8. Does SQLite3 not support foreign key constraints?
  9. SQLite – ORDER BY RAND()
  10. Query to get records based on Radius in SQLite?
  11. How do I add a foreign key to an existing SQLite table?
  12. How to use SQL Order By statement to sort results case insensitive?
  13. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  14. Is there AUTO INCREMENT in SQLite?
  15. Get month from DATETIME in sqlite
  16. GROUP_CONCAT in SQLite
  17. How do I import .sql files into SQLite 3?
  18. sqlite equivalent of row_number() over ( partition by …?
  19. Android multiple databases open
  20. Unfindable SQLite Syntax Error
  21. SQLite3 UNIQUE constraint failed error
  22. Does SQLite3 have prepared statements in Node.js?
  23. SQlite: select into?
  24. SQL error: misuse of aggregate
  25. SQLite query, ‘LIKE’
  26. How to use a calculated column by another calculated column
  27. UPSERT *not* INSERT or REPLACE
  28. Drop column from SQLite table
  29. converting int to real in sqlite
  30. Copy table structure to new table in sqlite3

Leave a Comment