conversion of a date/time column into serial date number and seperate time column

1 次查看（过去 30 天）
AA
AA 2015-10-28
回答： AA 2015-10-28
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
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 个评论
Thorsten
Thorsten 2015-10-28
编辑：Thorsten 2015-10-28
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
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 个）

Thorsten
Thorsten 2015-10-28
编辑：Thorsten 2015-10-28
s = '20050103 014800';
dat = datenum([s(1:8)], 'yyyymmdd')
min = sscanf(s(10:11), '%f')*60 + sscanf(s(12:13), '%f')
AA
AA 2015-10-28
thanks to both of you. how do i put the newly generated column 1 and column 2 together as a matrix with the remaining 4 columns in the table so that i have a matrix with 6 columns. i forgot to ask this question. thanks

类别

在 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