How do I insert datetime value into a SQLite database?

by

The format you need is:

'2007-01-01 10:00:00'

i.e. yyyy-MM-dd HH:mm:ss

If possible, however, use a parameterised query as this frees you from worrying about the formatting details.

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. How to return only the Date from a SQL Server DateTime datatype
  3. DateTime2 vs DateTime in SQL Server
  4. How can I list the tables in a SQLite database file that was opened with ATTACH?
  5. SQLite Reset Primary Key Field
  6. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  7. Get day of week in SQL Server 2005/2008
  8. How do I dump the data of some SQLite3 tables?
  9. SQLite – How do you join tables from different databases?
  10. How to determine the number of days in a month in SQL Server?
  11. Does SQLite3 not support foreign key constraints?
  12. MySQL’s now() +1 day
  13. SQLite – ORDER BY RAND()
  14. Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
  15. SQL Server convert string to datetime
  16. Query to get records based on Radius in SQLite?
  17. How to use SQL Order By statement to sort results case insensitive?
  18. Select random row(s) in SQLite
  19. sqlite alter table add MULTIPLE columns in a single statement
  20. Get month from DATETIME in sqlite
  21. How do I import .sql files into SQLite 3?
  22. sqlite equivalent of row_number() over ( partition by …?
  23. Generating dates between two dates
  24. How to create timestamp column with default value ‘now’?
  25. Getting Dates between a range of dates
  26. Convert INT to DATETIME (SQL)
  27. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  28. SQLite3 UNIQUE constraint failed error
  29. Does SQLite3 have prepared statements in Node.js?
  30. Copy table structure to new table in sqlite3

Leave a Comment