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'; ...
For more information on these data types, see your Oracle Rdb documentation. LONG VARCHAR varying-length column for character string data, which has 16,383 characters. LONG VARCHAR is equivalent to ...