Support JDBC date, time and timestamp escape sequences

Willena / sqlite-jdbc-crypt

SQLite JDBC Driver with encryption support

Apache License 2.0

172 stars 33 forks source link

Support JDBC date, time and timestamp escape sequences #63

Closed Chrriis closed 2 years ago

Chrriis commented 2 years ago

Hi,

JDBC drivers support the JDBC Date, Time, and Timestamp escape sequences.

Thus, the following is supposed to work using JDBC drivers (sometimes with addition of "FROM DUAL"): SELECT {d '2016-06-29'}, {ts '2016-06-29 11:07:35.123'}

Unfortunately, it is not supported by this driver. This causes compatibility issue where standard JDBC SQL fails.

Do you think you could do something about it?

(And thanks a lot for the updated project! The original Xerial one seems to be in limbo...)

Willena commented 2 years ago

Hi,

Sorry, this will probably never be implemented. Unless somebody is courageous enough to give it using a pull request.

Even if "Xerial one seems to be in limbo" you can still try to create an issue in their repo. I, for now, barely have the time to keep up with SQLite versions...