How do I convert datetime in string format to Matlab datetime?

14 次查看（过去 30 天）
Felicia Ojinji
Felicia Ojinji 2020-11-16
评论： Steven Lord 2020-11-16
I have 8760 rows of data in this format '02/01/2019 09'. I would like to convert this to Matlabe datetime format. Thank you

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

采纳的回答

Ameer Hamza
Ameer Hamza 2020-11-16
编辑：Ameer Hamza 2020-11-16
Try following InputFormat
x = '02/01/2019 09';
dt = datetime(x, 'InputFormat', 'dd/MM/yyyy hh')
Result
>> dt
dt =
datetime
02-Jan-2019 09:00:00
  3 个评论
显示 1更早的评论
Felicia Ojinji
Felicia Ojinji 2020-11-16
It worked... I added a space before the brackets initially that was why i got the error message. Thanks again Ameer
Steven Lord
Steven Lord 2020-11-16
Ran in:
That text you posted, '02/01/2019 09'. Does it represent January 2nd, 2019 at 9:00 AM? Or does it represent February 1st, 2019 at 9:00 AM? If the latter you want to use MM/dd/yyyy hh'.
s = '02/01/2019 09'
s = '02/01/2019 09'
J = datetime(s, 'InputFormat', 'dd/MM/yyyy hh')
J = datetime
02-Jan-2019 09:00:00
F = datetime(s, 'InputFormat', 'MM/dd/yyyy hh')
F = datetime
01-Feb-2019 09:00:00
Using the wrong format could lead to problems later on if you assumed one of the two potential formats by which s could be interpreted but a later entry is unambiguously in the other format, like:
datetime('20/01/2021', 'InputFormat', 'dd/MM/yyyy')
ans = datetime
20-Jan-2021
datetime('20/01/2021', 'InputFormat', 'MM/dd/yyyy') % Will error
Error using datetime (line 647)
Unable to convert '20/01/2021' to datetime using the format 'MM/dd/yyyy'.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by