I am runnning SQl Developer 2.1 and built a query which returns dates that letters were mailed and or correspondence received. My Query Results show normal date format (02-Mar-12) within Developer. When I export the results to Excel it includes the time stamp (02-MAR-12 06.13.20.000000000 PM). I had a coworker with an older version run the same query, when she exported the results the time stamps weren't exported, just the date. How can I change the export to remove the time stamp? Any help would be great. Thanks.
Clearly a bug. You can try changing your Tools|Preferences|Database|NLS|Timestamp Format to match the Date Format as a workaround. Otherwise why not upgrade to the lastest production SQL Developer release (3.1.07.42)? The bug does not occur there.
SQL Developer Team