[odb-users] dates and times in sqlite3

Boris Kolpackov boris at codesynthesis.com
Thu Jun 12 06:08:42 EDT 2014


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:


> 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.


More information about the odb-users mailing list