CSV Input date format
显示 更早的评论
Hello,
I'm trying to import a date string such as '01/10/2018 16:09:26,934';
However when doing the following:
DateString = '01/10/2018 16:09:26,934';
formatIn = 'MM/dd/yyyy HH:mm:SS,sss';
datetime(DateString,'InputFormat',formatIn)
It returns the following error:
Unable to parse '01/10/2018 16:09:26,934' as a date/time using the format 'MM/dd/yyyy HH:mm:SS,sss'.
Any ideas?
2 个评论
Jan
2018-1-10
Whenever you mention, that you get an error, post a copy of the complete message. It is easier to fix a problem than to guess the error.
Rodrigo Alvarez Hernandez
2018-1-10
采纳的回答
The seconds are lower case 'ss', the fractional seconds uppercase 'SSS':
formatIn = 'MM/dd/yyyy HH:mm:ss,SSS'
See the documentation of datetime: https://www.mathworks.com/help/matlab/ref/datetime.html#buhzxmk-1-Format
2 个评论
Rodrigo Alvarez Hernandez
2018-1-10
Jan
2018-1-10
You are welcome, Rodrigo. It is a well known fact, that the eyes of a programmer are blind for the problems, which are solved inside the brain already. Then it is useful to ask another person, who find the problem on the first view. I know this from my own experiences also :-)
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Time Series Objects 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
