Problem with datetime in German

28 次查看（过去 30 天）
Joshua
Joshua 2021-12-3
回答： Eric Sofen 2021-12-3
From a German language spreadsheet I have the following DateString: '21.Okt.2020'
where Okt is short for October.
How to read this as a datetime? According to the documentation the following should work, but unfortunately doesn't:
datetime('21.Okt.2020','Locale','de_DE','InputFormat','dd.MMM.yyyy')
Any advice would be greatly appreciated.
Regards

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2021-12-3
Ran in:
There does seem to be a problem with DATETIME handling the period characters (below).
Workaround: replace/remove the period characters, as per my first two examples.
datetime('21Okt2020','Locale','de_DE','InputFormat','ddMMMyyyy')
ans = datetime
21-Oct-2020
datetime('21-Okt-2020','Locale','de_DE','InputFormat','dd-MMM-yyyy')
ans = datetime
21-Oct-2020
datetime('21.Okt.2020','Locale','de_DE','InputFormat','dd.MMM.yyyy')
Error using datetime (line 651)
Unable to convert '21.Okt.2020' to datetime using the format 'dd.MMM.yyyy' and locale 'de_DE'.
  2 个评论
Stephen23
Stephen23 2021-12-3
Ran in:
In case anyone suggests to put the period character inside single quotes:
datetime('21.Okt.2020','Locale','de_DE','InputFormat','dd''.''MMM''.''yyyy')
Error using datetime (line 651)
Unable to convert '21.Okt.2020' to datetime using the format 'dd'.'MMM'.'yyyy' and locale 'de_DE'.

请先登录，再进行评论。

更多回答（2 个）

Eric Sofen
Eric Sofen 2021-12-3
We’re aware of the issues with parsing month abbreviations in some locales, and we're looking at ways to improve this. In this case, the "." following Okt is treated as part of the month abbreviation by the internationalization library we use. For now, the datetime format that works to parse the timestamp is:
datetime('21.Okt.2020','Locale','de_DE','InputFormat','dd.MMMyyyy')
(Notice no period after MMM.)
Walter Roberson
Walter Roberson 2021-12-3
Ran in:
Observe:
datetime('21.Oct.2020', 'InputFormat', 'dd.MMM.yyyy', 'Format', 'dd.MMM.yyyy')
ans = datetime
21.Oct.2020
So using dots is possible for English.
datetime('21-Okt-2020', 'Locale', 'de_DE', 'InputFormat', 'dd-MMM-yyyy', 'Format', 'dd.MMM.yyyy')
ans = datetime
21.Oct.2020
And using dashes is okay for German
datetime('21.Okt-2020', 'Locale', 'de_DE', 'InputFormat', 'dd.MMM-yyyy', 'Format', 'dd.MMM.yyyy')
ans = datetime
21.Oct.2020
and dot between the day and the month is ok in German
datetime('21.Okt.2020', 'Locale', 'de_DE', 'InputFormat', 'dd.MMM.yyyy', 'Format', 'dd.MMM.yyyy')
Error using datetime (line 651)
Unable to convert '21.Okt.2020' to datetime using the format 'dd.MMM.yyyy' and locale 'de_DE'.
But dot between the year and the month is not okay in German.
I do not know why this is... but see the following
  2 个评论
Walter Roberson
Walter Roberson 2021-12-3
编辑：Walter Roberson 2021-12-3
Ran in:
datetime('21.Okt..2020', 'Locale', 'de_DE', 'InputFormat', 'dd.MMM.yyyy', 'Format', 'dd.MMM.yyyy')
ans = datetime
21.Oct.2020
I do not know quite what to make of this.
Joshua
Joshua 2021-12-3
@Walter Roberson thanks for your effort, does indeed seem like an issue for Mathworks. In my case I have a bunch of different dates with often different formating. In the end I ended up parsing and replacing the '.' with '-' as both you and @Stephen suggested.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by