I have modified the DB2 and MySQL dialects to render date/time literals using the ANSI-standard syntax, instead of using JDBC escapes. This fixed a bug on DB2. I left the Oracle dialect using JDBC escapes (because time literals would have been real ugly), except for the special case of a timestamp literal with an offset/zone, where the JDBC driver doesn’t support it, and so I use the ANSI syntax. |