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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users