You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For some time, the sqlite module for Python3 has supported retrieving datetime fields from sqlite as datetime.datetime python objects.
If I do a call via a function direct to the database using the native sqlite module I am returned datetime.datetime objects.
If I do a call to the same function as part of a bottle view via bottle-sqlite, I'm returned strings in the format %Y-%m-%d %H:%M:%S.
It would be ideal if this module returned python datetime() rather than str(). This issue means that I currently have to have two near-identical functions - one that handles the string type and the other that handles the correct type.
The text was updated successfully, but these errors were encountered:
jameskirsop
changed the title
No support for datetime types
No support for detect_types
Jun 19, 2020
For some time, the sqlite module for Python3 has supported retrieving datetime fields from sqlite as
datetime.datetime
python objects.If I do a call via a function direct to the database using the native sqlite module I am returned
datetime.datetime
objects.If I do a call to the same function as part of a bottle view via bottle-sqlite, I'm returned strings in the format
%Y-%m-%d %H:%M:%S
.It would be ideal if this module returned python
datetime()
rather thanstr()
. This issue means that I currently have to have two near-identical functions - one that handles the string type and the other that handles the correct type.The text was updated successfully, but these errors were encountered: