search

hdbc / hdbc-sqlite3

Sqlite v3 driver for HDBC
BSD 3-Clause "New" or "Revised" License
21 stars 6 forks source link

toSql of a date doesn't play well with SqLite #1

Open jgoerzen opened 14 years ago

jgoerzen commented 14 years ago

Added by pepe iborra 2008-08-26 . ALL TEXT BELOW FROM SUBMITTER.

Sqlite treat dates as Strings, and for some reason comparisons don't work well with the EpochTime representation used by HDBC.

Google says the ISO 8601 representation solves that problem in Sqlite.