On 5 Feb 2019, at 4:58pm, Shawn Wagner <shawnw.mob...@gmail.com> wrote:
> 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. You're right. I somehow remembered the default as TEXT, not NUMERIC. I was wrong. Thanks for the correction. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users