Re: [sqlite] Bug: CAST string timestamp to TIMESTAMP truncates the value

2016-11-09 Thread Igor Tandetnik
On 11/9/2016 8:53 PM, Simon Slavin wrote: On 9 Nov 2016, at 4:44pm, Jiri Bajer wrote: sqlite> select CAST('1970-01-02 03:04:00.00' AS TIMESTAMP); SQLite has no TIMESTAMP type. See the "CAST expressions" section near the end of So the mystery b

Re: [sqlite] Bug: CAST string timestamp to TIMESTAMP truncates the value

2016-11-09 Thread Simon Slavin
On 9 Nov 2016, at 4:44pm, Jiri Bajer wrote: > sqlite> select CAST('1970-01-02 03:04:00.00' AS TIMESTAMP); SQLite has no TIMESTAMP type. See the "CAST expressions" section near the end of So the mystery becomes that of what happens if you write "CA

[sqlite] Bug: CAST string timestamp to TIMESTAMP truncates the value

2016-11-09 Thread Jiri Bajer
Hi sqlite devs, I am using SQLite wrapped by SQLAlchemy ORM and have encountered a weird behavior of CAST of a timestamp string to timestamp type as described at https://bitbucket.org/zzzeek/alembic/issues/391/batch-migration-on-sqlite-truncate : Steps to reproduce: sqlite> select CAST('1970