On 11/9/2016 8:53 PM, Simon Slavin wrote:
On 9 Nov 2016, at 4:44pm, Jiri Bajer <sari...@seznam.cz> wrote:
sqlite> select CAST('1970-01-02 03:04:00.000000' AS TIMESTAMP);
SQLite has no TIMESTAMP type. See the "CAST expressions" section near the end
of
<https://www.sqlite.org/lang_expr.html>
So the mystery becomes that of what happens if you write "CAST (11.5 AS FRED)".
The documentation doesn't seem to mention this.
It is in fact documented, between
https://www.sqlite.org/lang_expr.html#castexpr and
https://www.sqlite.org/datatype3.html#affname . CAST(expr AS name)
determines affinity from `name`, then coerces the value of `expr`
according to that affinity. The default affinity, when no specific rules
apply, is NUMERIC.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users