how to get serial date numbers?

5 次查看（过去 30 天）

UPT 2012-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48301-how-to-get-serial-date-numbers

hello.i have a structure like this: data = struct('Date', {cell(2208,1)}, 'Hour', {zeros(2208,1)}, 'DryBulb', {zeros(2208,1)}, 'DewPnt', {zeros(2208,1)}, 'SYSLoad', {zeros(2208,1)}, 'NumDate', {zeros(2208,1)});.. 'Date' has 92 days and 'Hour' has 24 hours,from 1 to 24.how can i express 'Date' and 'Hour' in serial date numbers and to present these serial date numbers in 'NumDate'?thank you

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2012-9-16

Duplicate is at http://www.mathworks.co.uk/matlabcentral/answers/48295-how-to-modify-a-structure

请先登录，再进行评论。

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

采纳的回答

per isakson 2012-9-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48301-how-to-get-serial-date-numbers#answer_59002

编辑：per isakson 2012-9-20

在 MATLAB Online 中打开

Hint:

    sdn = bsxfun( @plus, [0:91], transpose([0:23]/24) );
    datestr( sdn(1  ), 'yyyy-mm-dd HH:MM:SS' )
    datestr( sdn(end), 'yyyy-mm-dd HH:MM:SS' )
    data.NumDate = sdn(:);

--- Working code in response to comment ---

Try this

    sd1 = datenum( ' 1 Jan 2004', 'dd mmm yyyy' );     
    sd2 = datenum( '31 Mar 2004', 'dd mmm yyyy' );
    sdn = bsxfun( @plus, [sd1:1:sd2], transpose([0:23]/24) );
    datestr( sdn(  1), 'yyyy-mm-dd HH:MM:SS' )
    datestr( sdn(end), 'yyyy-mm-dd HH:MM:SS' )

This code avoids round-off errors in sdn(1,:)

    >> sdn( 1, 1:5 )
    ans =
          731947      731948      731949      731950      731951
    >> all( sdn(1,1:5) == [ 731947, 731948, 731949, 731950, 731951 ] )
    ans =
         1

Whether it is wise to rely on this for comparisons is questionable

And to make sdn a column vector

sdn = sdn(:);

7 个评论
显示 5更早的评论隐藏 5更早的评论

per isakson 2012-9-19

编辑：per isakson 2012-9-20

A hint is a hint nothing more. I'm convinced one should not use code, which one doesn't understand. Seriously, there is nothing in my hint that could possibly account for your dates.

See my answer above

UPT 2012-9-19