SQLite date fields

Tim Roberts timr at probo.com
Mon Nov 29 05:22:15 CET 2010

Duncan Booth <duncan.booth at invalid.invalid> wrote:

>Tim Roberts <timr at probo.com> wrote:
>>>However, when it comes to writing-back data to the table, SQLite is
>>>very forgiving and is quite happy to store '25/06/2003' in a date
>> SQLite is essentially typeless.  ALL fields are stored as strings,
>> with no interpretation.  You can store whatever you want in any
>> column.  The column types are basically there to remind YOU how to
>> handle the data. 
>Not all fields are stored as strings; they may also be stored as 
>integer, floating point values or binary data.

Sorry.  Up through SQLite version 2, ALL fields were stored as strings,
even if you typed them as integers or floats.  I see that has changed in
Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.

More information about the Python-list mailing list