Return
-
Title
When I click on a date field to highlight and copy it within a data grid, Toad re-formats the dat -
Description
When I click on a date field to highlight and copy it within a data grid, Toad re-formats the date format dd/mm/yyyy to a different one regardless of my Oracle database & Toad settings. -
Cause
The settings within the date grid output that are generated by an Execute statement (F9) are not controlled by Toad, they are set by Windows (operating system) -
Resolution
WORKAROUND 1:
The date format can be adjusted from within the control panel. Please go to the following location: Control Panel -> regional settings -> customize -> date tab -> short date format. Note that Microsoft does not offer dd-mmm-yyyy.
WORKAROUND 2:
Execute the query as script (f5). The date can be highlighted and copied from the first tab(Output) or select the second tab, which is another grid. This Grid does not attempt to auto select a different date or convert the date to the Windows default.