Recent content by AmyG

PS Highlighting results and Copy with Header and pasting into Excel can also work in many cases...however, that has issues with dropping leading zeroes on different (non-date) fields. Such as 0123, when pasted, is turned to 123.

I can't add a preference of "Date fields to_char" because then 1/1/1800 shows up as 01-JAN-00...which is ambiguous with the 2-digit year. I can, in select cases, add a to_char in the query (where I can define the format); however, for some of my blanket testing, this would require thousands of...

Hi, I have a new version of PL/SQL Developer (v12) on a new laptop that has Excel Office 365 ProPlus. (Previously used PL/SQL Dev v9 and some earlier version of Excel). NOW when I have query results and "Copy to Excel", my low-dates (1/1/1800) show up as all ####### with a value (when I put...