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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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 (-).
Ursache

This is not a Toad issue but a environment configuration (or a Locale setting issue).
Lösung

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 übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Artikelhistorie:: Erstellt am: 10/17/2016
Letzte Aktualisierung am: 5/7/2023

Titel