When I click on a date field to highlight and copy it within a data grid, Toad re-formats the dat (4292020)

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

When I click on a date field to highlight and copy it within a data grid, Toad re-formats the dat
Descrição

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.
Causa

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)
Resolução

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.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título