Not able to display dateformat set as mmm/dd/yyyy hh:mm:ss AM/PM in Excel after export. (4315455)

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

Not able to display dateformat set as mmm/dd/yyyy hh:mm:ss AM/PM in Excel after export.
Descrição

The OS language is set to Korean. After setting the Date Format Editor using separator slash(/) in Toad.
Date was not able to display as format of mmm/dd/yyyy hh:mm:ss AM/PM in Excel spreadsheet after exported from Toad.
However, Date can be display in Excel as other format as date separator dot(.) and date separator dash (-).
Causa

This is not a Toad issue but a environment configuration (or a Locale setting issue).
Resolução

1. Go to Control Panel
2. Select Clock, Language, and Region
3. Under Region and Language,
Select 'Change the date, time, or number format'
4. Click on Additional settings.
5. Select Date tab
6. You should see 'yyyy-MM-dd'
Edit the date, type in 'yyyy/MM/dd' into the it.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título