SQLite date fields

[Tim Roberts]

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
>>>field, 
>> 
>> 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
v3.
-- 
Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.