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'; ...
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 ...