How to read datetime back from sqlite as a datetime instead of string in Python?

by

If you declare your column with a type of timestamp, you’re in clover:

>>> db = sqlite3.connect(':memory:', detect_types=sqlite3.PARSE_DECLTYPES)
>>> c = db.cursor()
>>> c.execute('create table foo (bar integer, baz timestamp)')
<sqlite3.Cursor object at 0x40fc50>
>>> c.execute('insert into foo values(?, ?)', (23, datetime.datetime.now()))
<sqlite3.Cursor object at 0x40fc50>
>>> c.execute('select * from foo')
<sqlite3.Cursor object at 0x40fc50>
>>> c.fetchall()
[(23, datetime.datetime(2009, 12, 1, 19, 31, 1, 40113))]

See? both int (for a column declared integer) and datetime (for a column declared timestamp) survive the round-trip with the type intact.

More Related Contents:

  1. parameter unsupported when inserting int in sqlite
  2. Parameter unsupported when inserting int
  3. How to print a date in a regular format?
  4. Convert UTC datetime string to local datetime
  5. How to make a timezone aware datetime object in Python?
  6. Pandas Dataframe line plot display date on xaxis
  7. Adding days to a date in Python
  8. How to convert integer timestamp into a datetime
  9. How do you convert a time.struct_time object into a datetime object?
  10. How to round the minute of a datetime object
  11. In Python, how do you convert seconds since epoch to a `datetime` object?
  12. How do I create a datetime in Python from milliseconds?
  13. What’s the best way to find the inverse of datetime.isocalendar()?
  14. How to get FTP file’s modify time using Python ftplib
  15. How to group a pandas dataframe by a defined time interval?
  16. HDF5 – concurrency, compression & I/O performance [closed]
  17. Convert Pandas Series to DateTime in a DataFrame
  18. Convert dataframe index to datetime
  19. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  20. Is this Python code vulnerable to SQL injection? (SQLite3)
  21. pysqlite: Placeholder substitution for column or table names?
  22. How to get current date and time from GPS unsegment time in python
  23. How to convert a Date string to a DateTime object?
  24. Group DataFrame in 5-minute intervals
  25. Python SQLite3 SQL Injection Vulnerable Code
  26. What values are valid in Pandas ‘Freq’ tags?
  27. Python and SQLite: insert into table
  28. need to convert UTC (aws ec2) to PST in Python
  29. Convert dates to pd.to_datetime where month could be either a number or month name
  30. Pandas: select all dates with specific month and day

Leave a Comment