how to get serial date numbers?
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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
Akzeptierte Antwort
per isakson
am 16 Sep. 2012
Bearbeitet: per isakson
am 20 Sep. 2012
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 Kommentare
per isakson
am 19 Sep. 2012
Bearbeitet: per isakson
am 20 Sep. 2012
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!