SQLite date format issues

[hraberg]

See https://circleci.com/gh/juxt/crux/2429
java.lang.NumberFormatException: For input string: ".20018E.200184E4"

And https://circleci.com/gh/juxt/crux/2416
#inst "2019-07-07T12:24:32.019-00:00" vs
#inst "2019-08-07T12:24:32.019-00:00"
(Different months.)

[hraberg]

Maybe related? xerial/sqlite-jdbc#88

[hraberg]

Why are dates treated as strings and parsed, isn't there native dates or timestamps in SQLite?

[hraberg]

This test has a few cases which deals with dates:
https://github.com/xerial/sqlite-jdbc/blob/master/src/test/java/org/sqlite/QueryTest.java

[hraberg]

An alternative would be to simply use longs inside the db.

[hraberg]

Also, the current use of a global SimpleDateFromat isn't thread safe.

[hraberg]

^ above might fix this, but there's no real reason to assume the tests have had threading issues, so we'll see.

[hraberg]

Haven't seen this in a while now, assuming the fix above solved it. We'll reopen if not.