Hello. I'm trying to use function "Copy to Excel" on results of this query:
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?
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?