Reread the rules at the start of 3.1. TIME doesn't have any of the substrings used to indicate a particular other affinity, so it's treated as NUMERIC.
On Tue, Feb 5, 2019, 8:53 AM Simon Slavin <slav...@bigfraud.org wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users