sqlite database default time value ‘now’

by

i believe you can use

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

as of version 3.1 (source)

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. SQLite – UPSERT *not* INSERT or REPLACE
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. Update table values from another table with the same user name
  5. SQL Select between dates
  6. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  7. What are valid table names in SQLite?
  8. FULL OUTER JOIN with SQLite
  9. Delete column from SQLite table
  10. How do I insert datetime value into a SQLite database?
  11. How to get a list of column names on Sqlite3 database?
  12. Select random row(s) in SQLite
  13. basic recursive query on sqlite3?
  14. SQLite and custom order by
  15. Drop all tables command
  16. SQLite auto-increment non-primary key field
  17. GROUP_CONCAT in SQLite
  18. How to do IF NOT EXISTS in SQLite
  19. Core Data Performance with Single Parent Entity
  20. Match only entire words with LIKE?
  21. What is causing Foreign Key Mismatch error?
  22. How to create timestamp column with default value ‘now’?
  23. String concatenation does not work in SQLite
  24. How to split comma-separated values?
  25. sqlite select with condition on date
  26. Unfindable SQLite Syntax Error
  27. SQLite Order By Date1530019888000
  28. SQL – Inserting a row and returning primary key
  29. How to select the first N rows of each group?
  30. Copy table structure to new table in sqlite3

Leave a Comment