Way to import time series date string as mm-dd-yyyy

Question

Chris 2011-9-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16259-way-to-import-time-series-date-string-as-mm-dd-yyyy

My data is in the format of mm-dd-yyyy hh:mm:ss however it seems like the time series import tool will only import dates & time data if the format is in dd-mmm-yyyy hh:mm:ss

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2011-9-20

What exactly is your question? Can you post the type of the available input and wanted output?

请先登录，再进行评论。

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

Answer 1

Jan 2011-9-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16259-way-to-import-time-series-date-string-as-mm-dd-yyyy#answer_21993

在 MATLAB Online 中打开

You can convert the data manually:

S1 = '07-12-2011 13:14:15'
D  = datenum(S1, 'mm-dd-yyyy HH:MM:SS');
S2 = datestr(D,  'dd-mmm-yyyy HH:MM:SS')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Chris 2011-9-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16259-way-to-import-time-series-date-string-as-mm-dd-yyyy#answer_22034

Hi Jan

I am using the tsimport tool however the date time import only accepts the 3 digit month and not 2 digit month with the time. I have to have both the time and dates in the time series.

http://www.mathworks.com/help/techdoc/ref/timeseriesclass.html#inputarg_time

2 个评论
显示无隐藏无

Jan 2011-9-20

Sorry for repeating: What is your question? How can we help you?

Fangjun Jiang 2011-9-20

Time series supports all the data format. What tsimport tool are you using?

请先登录，再进行评论。

Answer 3

Chris 2011-9-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16259-way-to-import-time-series-date-string-as-mm-dd-yyyy#answer_22072

Thanks when I run tstool, and go file create time series from file. I then select a csv file. Columns A & B which are the date and time are in the format mm:dd:yyy and column b is the time as hh:mm:ss

I would like my time series imported to have both the date and time. However under the specify time vector, define it now date string option for format there is only dd-mmm-yyy hh:mm:ss which unfortunately requires a 3 character month such as 20-sep-2011. Unfortunately my data files are 20-09-2011. Is there a way for it to easily convert the 09 to Sep or have the tstool change the 09 to sep.