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