Error with very old dates on export to excel

Wanted

Member
Hello. I'm trying to use function "Copy to Excel" on results of this query:

SQL:
select to_date('01.01.0001','dd.mm.yyyy') mydate from dual
union all
select to_date('01.01.0101','dd.mm.yyyy') from dual
union all
select to_date('01.01.2001','dd.mm.yyyy') from dual

In PL/SQL Developer Version 13.0.5.1908 (64 bit) I'm getting an error: "Invalid value for parameter "Date": -693593 is not on the range."

In PL/SQL Developer Version 12.0.7.1837 (64 bit) export works fine but first two dates appear as ##### as Excel cannot convert negative numbers to dates.

In PL/SQL Developer Version 9.0.6.1665 export works fine and first two dates appear as text, third appear as date.

Can you implement version 9 behavior in latest version?
 
Back
Top