[odb-users] dates and times in sqlite3

[MM]

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.

MM