conversion of a date/time column into serial date number and seperate time column
显示 更早的评论
I have a table in table format and it has 6 columns and 6 million rows.
The first column has dates and time in such a format '20050103 014800' which stands for 3rd January 2005 01:48:00.
I want the date of the first column to be converted into a date serial number which can be recognized by matlab (ie. via datenum). The time section I want to put into a seperate adjacent column in the format 00:00-->0, 00:01-->1 up until 23:59-->1439. can anyone help me? thanks
采纳的回答
Ingrid
2015-10-28
use datenum and a format specifier (assuming X is your variable and Y is the requested variable)
numFormat = datenum(X{:,1},'yyyymmdd HHMMSS');
Y(:,1)= round(numFormat);
Y(:,2)= hour(numFormat)*60 + minute(numFormat);
2 个评论
round will code the next day if hours >= 12. That will give identical results for, e.g.,
'20050103 124800'
'20050104 004800'
Use floor instead.
Ingrid
2015-10-28
indeed a very valid remark, you just want to remove the values after the point and not use round, sorry for my mistake
更多回答（2 个）
s = '20050103 014800';
dat = datenum([s(1:8)], 'yyyymmdd')
min = sscanf(s(10:11), '%f')*60 + sscanf(s(12:13), '%f')
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
Translated by 
