On 5 Feb 2019, at 4:11pm, David Raymond <david.raym...@tomtom.com> wrote:

> "Time(8)" ends up as  numeric affinity for that field.

The table in 3.1.1 shows how SQLite recognises the type you supply and turns it 
into a type it can use.  The lowest row of the table shows that "DATETIME" is 
recognised as NUMERIC.  However, it lists "DATETIME" specifically, not "TIME".

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to