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

Datenum date conversion troubles

1 次查看（过去 30 天）
Aaron
Aaron 2012-7-31
I have a matlab file of timestamps called d that looks like this...
'7/31/2012 2:35:00 PM'
'7/31/2012 2:36:00 PM'
'7/31/2012 2:37:00 PM'
'7/31/2012 2:38:00 PM'
'7/31/2012 2:39:00 PM'
'7/31/2012 2:40:00 PM'
and I am trying to put these timestamps into matlab so I can graph the data. so I have tried
CR100.time = datenum(d(:,1),'mm/dd/yyyy HH:MM:SS Ww')
But I am getting the response...
??? Error using ==> datenum at 182 DATENUM failed.
Caused by: Error using ==> dtstr2dtnummx Failed on converting date string to date number.
Any clue how to import these timestamps?
Also do you know how I can save an excel file in a matlab script.

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

回答（3 个）

the cyclist
the cyclist 2012-7-31
编辑：the cyclist 2012-7-31
I suspect it is the 'Ww' that is tripping you up. Try
datenum(d,'mm/dd/yyyy HH:MM:SS PM')
Thomas
Thomas 2012-7-31
Just try something like:
str={'7/31/2012 2:35:00 PM'
'7/31/2012 2:36:00 PM'
'7/31/2012 2:37:00 PM'
'7/31/2012 2:38:00 PM'
'7/31/2012 2:39:00 PM'
'7/31/2012 2:40:00 PM'}
date_time=datenum(str)
Aaron
Aaron 2012-7-31
I just tried that and I get
??? Error using ==> datenum at 182 DATENUM failed.
Caused by: Error using ==> dtstr2dtnummx Failed on converting date string to date number.
  3 个评论
显示 1更早的评论
Aaron
Aaron 2012-7-31
sorry. d is a data structure of the type {} in the matlab workspace. It is only one column with many rows filled with strings like the ones posted previously.
the cyclist
the cyclist 2012-7-31
My advice would be to use my code on subset of d [such as d(1:5), then d(6:10), etc] until you can identify some entries of d that are causing the problem.

请先登录，再进行评论。

类别

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