清空筛选条件
清空筛选条件

Transformation of Date

1 次查看（过去 30 天）
Mtlb Usr
Mtlb Usr 2011-2-24
Hi,
I have a issue with several dates that I receive from a macro with numeric format. Then, When I want to transform to string format in matlab, the date doesn't keep the original format.
For example:
12/03/11 05:04:30 --> num --> datestr(num,'dd-mm-yy HH:MM:SS')--> 13/03/0111 05:04:30
How can I revolve this issue?
thanks
regards

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

采纳的回答

Mtlb Usr
Mtlb Usr 2011-2-24
Hi,
Sorry I have confused. The issue is that the number that I get from a macro is in the 1900/01/01 base of date. However, in matlab the base of date is 0000/01/01.
I have to check this difference for resolve the issue.
regards.
  2 个评论
Andreas Goser
Andreas Goser 2011-2-24
When you "macro" - that is somethin in MS Excel?
Mtlb Usr
Mtlb Usr 2011-2-24
Hi,
Yes, that is.
regards

请先登录，再进行评论。

更多回答（2 个）

Jan
Jan 2011-2-24
Extremely strange. Please edit your question and insert the original code you used for this and mention the Matlab version.
In Matlab 2009a I get:
S = '12/03/11 05:04:30'
num = datenum(S)
datestr(num, 'dd-mm-yy HH:MM:SS')
>> '03-12-11 05:04:30'
The result is as expected. The result you get '13/03/0111 05:04:30' is surprising: where do the '/' come from?!
Andreas Goser
Andreas Goser 2011-2-24
  1 个评论
Mtlb Usr
Mtlb Usr 2011-2-24
Hi Andreas,
You are right.
I have resolved with a similar solution.
thanks
regards

请先登录，再进行评论。

类别

在 Help Center 和 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