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

date and time serial conversion

1 次查看（过去 30 天）
AA
AA 2014-11-4
编辑： per isakson 2014-11-5
I have a table with one million rows and 5 columns. The first column has the dates and the second column the time. I want toconvert the date and time to a number as i want to turn the table into a matrix and a matrix cannot have date and time.
  4 个评论
显示 2更早的评论
per isakson
per isakson 2014-11-4
"appear as 26072004" &nbsp Why do you want it that way? To me that is asking for problems down the road.
AA
AA 2014-11-4
you are right. datenum format is better. How do I change it into datenum format?

请先登录，再进行评论。

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

采纳的回答

per isakson
per isakson 2014-11-4
编辑：per isakson 2014-11-5
Hint:
>> sdn = datenum('04.11.2014','dd.mm.yyyy' )
sdn =
735907
Matlabs serial date number and
>> [60,1]*sscanf( '12:48', '%2d:%2d')
ans =
768
minutes after midnight
A nice thing about this is that you get integers (flint) and do not need to worry about precision when you do comparisons.
&nbsp
Some code added
fid = fopen('AA.txt');
cac = textscan( fid, '%s%s%f' );
fclose(fid)
[60,1]*sscanf( transpose(char(cac{2})),'%2d:%2d', [2,inf] )
returns
ans =
767 768 769
where &nbsp AA.txt &nbsp contains
04.11.2014 12:47 1
04.11.2014 12:48 2
04.11.2014 12:49 3
  2 个评论
AA
AA 2014-11-4
how can i incorporate the table into the time command. x variable is the the column that has the values for time and i get the following error:
b=[60,1]*sscanf(x, '%2d:%2d') Error using sscanf First argument must be a string.
per isakson
per isakson 2014-11-4
编辑：per isakson 2014-11-4
"the table" &nbsp what do you mean by table? Do you mean a text-file?
"x" &nbsp what is x?

请先登录，再进行评论。

更多回答（1 个）

Michael Haderlein
Michael Haderlein 2014-11-4
You can use datenum:
datevec(datenum('04.11.2014 12:48','dd.mm.yyyy HH:MM'))
ans =
2014 11 4 12 48 0
  1 个评论
AA
AA 2014-11-4
I want the date to be converted to one integer and stay in the same column and row. the table variable is called x

请先登录，再进行评论。

类别

在 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