SQLite date fields
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