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

Reply via email to