SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[BUG] SQLDeveloper 18.1 wrong date

BgilisMay 28 2018 — edited May 31 2018

Hello,

I noticed yesterday SqlDeveloper is not displaying the correct date for pre gregorian dates (from 14/10/1582).

Exemple: SELECT to_date('01/01/0001', 'DD/MM/YYYY') AS d from dual;

Will display 03/01/0001. It works well in sqlplus but not in SqlDeveloper 18.01.

Can you reproduce?

Regards

This post has been answered by thatJeffSmith-Oracle on May 29 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2018

Added on May 28 2018

#sql-developer

16 comments

3,076 views