Transformation of Date

2011 2 24
3 个回答
回答已采纳
4 次查看（30 天）

0 个投票

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

0 个投票

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

1 个投票

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 个投票

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

Mtlb Usr
Mtlb Usr 2011-2-24
Hi Andreas,
You are right.
I have resolved with a similar solution.
thanks
regards

请先登录，再进行评论。

类别

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