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 <[email protected] wrote: > On 5 Feb 2019, at 4:11pm, David Raymond <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
