GitHub

oracle.to_date with Julian Days format returns wrong results

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

nls_time_format.sql

alter session set nls_timestamp_format='yyyy-mm-dd hh24:mi:ssxff'; alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; alter session set nls_timestamp_tz_format = 'yyyy-mm-dd hh24:mi:ss tzh:tzm ...