[odb-users] dates and times in sqlite3

[Boris Kolpackov]

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