I have found an issue with the 'J' format of the oracle.to_date(text, text) function, it reports wrong results compared to Oracle. On Oracle: SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'; ...
This problem is handled for oracle.sql.TIMESTAMP in org.springframework.jdbc.support.JdbcUtils class, but still exists for oracle.sql.DATE. In Oracle my database column is declared as TIMESTAMP(6).
Abstract: SQL language is a non-procedural language with the defined statements and available clauses. Many times, conditions and format of the output depend on the functions. In this paper, Oracle ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results