When I run a query, select the results and then use the "Copy to Excel" function, it appears that the time portion of Date fields is truncated.
In PL/SQL Developer the field shows as: 1/1/1900 9:06:00 AM Excel shows: 1/1/1900 (and I checked that it isn't just formatting) If I just use copy (ctrl-c) and then paste it into Excel I get the correct information: 1/1/1900 9:06:00 AM
Any chance this will be fixed in the 8.0 upgrade? (I am using 7.1.5.1398.)
It would be great if you could fix it as part of the 8.0 release, because in the data we get the date portion is 1/1/1900 if only the time portion is supplied, but sometimes the date is there, and we need it too.