Steps to reproduce the issue:
alter session set NLS_DATE_FORMAT = 'SYYYY.MM.DD';
alter session set NLS_TIME_FORMAT = 'HH24.MI.SSXFF';
alter session set NLS_TIMESTAMP_FORMAT = 'SYYYY.MM.DD HH24.MI.SSXFF';
alter session set NLS_TIME_TZ_FORMAT = 'HH24.MI.SSXFF TZR';
alter session set NLS_TIMESTAMP_TZ_FORMAT = 'SYYYY.MM.DD HH24.MI.SSXFF TZR';
select to_char(to_date(2,'J'),'SYYYY.MM.DD'), to_date(2,'J') from dual;
Output:
TO_CHAR(TO_DATE(2,'J'),'SYYYY.MM.DD') TO_DATE(2,'J')
------------------------------------- --------------
-4712.01.02 04712.01.02
Expected Output (same as SQL Developer):
TO_CHAR(TO_DATE(2,'J'),'SYYYY.MM.DD') TO_DATE(2,'J')
------------------------------------- --------------
-4712.01.02 -4712.01.02 Grid Output is also incorrect.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center