converting a date column with yyyymmdd to matlab date number?

8 次查看（过去 30 天）
Danielle Leblance
回答： Peter Perkins 2018-5-14
Hi ,
I have a double(not a string)column where each observation is a number with the following format yyyymmdd.How can I convert this column to a column of matlab date numbers. for example, how can I convert 19960530 to 729175

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

采纳的回答

Star Strider
Star Strider 2018-5-6
This seems to work:
ymdCol = [19960530; 19960531; 19960601; 19960602] % Create Column
DN = datenum(num2str(ymdCol), 'yyyymmdd')
ymdCol =
19960530
19960531
19960601
19960602
DN =
729175
729176
729177
729178

更多回答（1 个）

Peter Perkins
Peter Perkins 2018-5-14
Danielle, you may have your reasons for wanting a datenum, but I'd suggest using datetime, for which there's an easy conversion:
>> datetime([19960530;19960531],'ConvertFrom','yyyymmdd')
ans =
2×1 datetime array
30-May-1996 00:00:00
31-May-1996 00:00:00

类别

在 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