How do I convert datetime in string format to Matlab datetime?
显示 更早的评论
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
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 个评论
Felicia Ojinji
2020-11-16
Felicia Ojinji
2020-11-16
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'
J = datetime(s, 'InputFormat', 'dd/MM/yyyy hh')
F = datetime(s, 'InputFormat', 'MM/dd/yyyy hh')
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')
datetime('20/01/2021', 'InputFormat', 'MM/dd/yyyy') % Will error
更多回答（0 个）
类别
在 帮助中心 和 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 
