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

2011 9 20
3 个回答
回答已采纳
31 次查看（30 天）

0 个投票

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
Jan 2011-9-20
What exactly is your question? Can you post the type of the available input and wanted output?

请先登录，再进行评论。

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

 采纳的回答

Jan
Jan 2011-9-20

0 个投票

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')

更多回答（2 个）

Chris
Chris 2011-9-20

0 个投票

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
Jan 2011-9-20
Sorry for repeating: What is your question? How can we help you?
Fangjun Jiang
Fangjun Jiang 2011-9-20
Time series supports all the data format. What tsimport tool are you using?

请先登录，再进行评论。

Chris
Chris 2011-9-21

0 个投票

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.

类别

在 帮助中心 和 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