Hi Horst, SQLite doesn't really have any data types, so I'm not sure if we can really say that either timestamp formatting is specific to any SQLite subdialect. But in any case, we should definitely attempt to parse the ISO standard timestamp format (including a T) in addition to the JDBC format (without the T).
I have created an issue for this: https://github.com/jOOQ/jOOQ/issues/7325 We'll continue to *write* timestamps in JDBC format (without the T), but we can definitely read both formats. Hope this helps, Lukas 2018-03-18 17:13 GMT+01:00 Horst Fiedler <[email protected]>: > Seems to be caused by sqlite as it happens with pure JDBC too: > > Caused by: java.text.ParseException: Unparseable date: > "2014-09-22T12:10:00" does not match > (\p{Nd}++)\Q-\E(\p{Nd}++)\Q-\E(\p{Nd}++)\Q > \E(\p{Nd}++)\Q:\E(\p{Nd}++)\Q:\E(\p{Nd}++)\Q.\E(\p{Nd}++) > at org.sqlite.date.FastDateParser.parse(FastDateParser.java:299) > at org.sqlite.date.FastDateFormat.parse(FastDateFormat.java:490) > at org.sqlite.jdbc3.JDBC3ResultSet.getTimestamp(JDBC3ResultSet.java:529) > > but using simple JDBC it is easy to overcome > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
