Parameter unsupported when inserting int

by

Note the added comma after “temp” below:

cur.execute('insert into new_test (curent_dt) values (?)', (temp,))

The reason this happens is that (temp) is an integer but (temp,) is a tuple of length one containing temp.

More Related Contents:

  1. parameter unsupported when inserting int in sqlite
  2. How to read datetime back from sqlite as a datetime instead of string in Python?
  3. Converting between datetime, Timestamp and datetime64
  4. Iterating through a range of dates in Python
  5. Parsing date with timezone from an email?
  6. Can’t subtract offset-naive and offset-aware datetimes
  7. Convert datetime to Unix timestamp and convert it back in python
  8. Find the closest date to a given date
  9. How to increment a datetime by one day?
  10. OperationalError: database is locked
  11. Sqlite3, OperationalError: unable to open database file
  12. How to get current time in python and break up into year, month, day, hour, minute?
  13. Fetching datetime from float in Python
  14. “import datetime” v.s. “from datetime import datetime”
  15. How do you convert a datetime/timestamp from one timezone to another timezone?
  16. Why does datetime.datetime.utcnow() not contain timezone information?
  17. Bulk insert huge data into SQLite using Python
  18. Convert a column of datetimes to epoch in Python
  19. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  20. “no such table” exception
  21. How to convert epoch time with nanoseconds to human-readable?
  22. Python pandas integer YYYYMMDD to datetime
  23. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  24. Formatting “yesterday’s” date in python
  25. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  26. Python: Datetime to season
  27. finding last business day of a month in python
  28. Python strptime parsing year without century: assume prior to this year?
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment