[odb-users] dates and times in sqlite3

MM finjulhich at gmail.com
Thu Jun 12 08:19:40 EDT 2014

On 12 June 2014 11:08, Boris Kolpackov <boris at codesynthesis.com> wrote:

> Hi,
> MM <finjulhich at gmail.com> writes:
> > By default, *date* converts to extended iso string like so YYYY-MM-DD,
> > and *time_duration* converts to HH:MM:SS.fffffffff were fff is fractional
> > seconds that are only included if non-zero.
> >
> > For both, the default column type is TEXT.
> Yes, SQLite does not have date-time data types. These representations,
> however, are pretty standard. See this page, for example:
> http://www.sqlite.org/lang_datefunc.html
> > 1. for date, is this compatible with the default pysqlite3 converter for
> > datetime.date?
> Maybe someone else on the mailing list will be able to answer this,
> but generally, this mailing list is a wrong place to ask what a Python
> default converter might do. The relevant Python mailing list would be a
> much more sensible place.
> Boris
I'm sorry I put odb's mailing list in CC rather than in To just for the
benefits of others.
The email was sent To the author of pysqlite.


More information about the odb-users mailing list