parameter unsupported when inserting int in sqlite

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. How to read datetime back from sqlite as a datetime instead of string in Python?
  2. Parameter unsupported when inserting int
  3. How to convert local time string to UTC?
  4. Filtering Pandas DataFrames on dates
  5. Variable table name in sqlite
  6. How to print pandas DataFrame without index
  7. Converting string with UTC offset to a datetime object [duplicate]
  8. How do I convert a datetime to date?
  9. Convert string date to timestamp in Python
  10. Getting today’s date in YYYY-MM-DD in Python?
  11. type object ‘datetime.datetime’ has no attribute ‘datetime’
  12. Python insert numpy array into sqlite3 database
  13. Splitting timestamp column into separate date and time columns
  14. Extract day of year and Julian day from a string date
  15. Get year, month or day from numpy datetime64
  16. Convert string “Jun 1 2005 1:33PM” into datetime
  17. Python time to age, part 2: timezones [duplicate]
  18. Python pandas convert datetime to timestamp effectively through dt accessor
  19. Which is the fastest way to extract day, month and year from a given date?
  20. Get time zone information of the system in Python?
  21. Locate first and last non NaN values in a Pandas DataFrame
  22. Format of datetime in pyplot axis
  23. How to convert Python’s .isoformat() string back into datetime object [duplicate]
  24. SQLite, python, unicode, and non-utf data
  25. Pycharm environment different than command line
  26. Python summing up time
  27. Ceil a datetime to next quarter of an hour
  28. Clean way to convert quarterly periods to datetime in pandas
  29. Python: Matplotlib avoid plotting gaps
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment