how to get serial date numbers?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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
Risposta accettata
per isakson
il 16 Set 2012
Modificato: per isakson
il 20 Set 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 Commenti
per isakson
il 19 Set 2012
Modificato: per isakson
il 20 Set 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!