Info

This question is closed. Reopen it to edit or answer.

mutiple reading and writing of date and time

2 views (last 30 days)
KRUNAL
KRUNAL on 6 Aug 2014
Closed: MATLAB Answer Bot on 20 Aug 2021
My data is as follows:
OriginTime Year Month Day Hour Minute Second
51.65086761 2014 6 10 12 9 5.991625
53.03222393 2014 6 10 12 9 5.991625
52.47999444 2014 6 10 12 9 5.991625
52.55764572 2014 6 10 12 9 5.991625
52.73042468 2014 6 10 12 9 5.991625
53.68612011 2014 6 10 12 9 5.991625
53.51039291 2014 6 10 12 9 5.991625
52.5239488 2014 6 10 12 9 5.991625
52.41107716 2014 6 10 12 9 5.991625
52.69466268 2014 6 10 12 9 5.991625
Here I want to 1st merge 'Hour','minute' and 'Second' column as hh:mm:ss and then add those time with the OriginTime column data I also want to merge 'Year','month' and 'Day' column data into mm/dd/yyyy. Can anyone tell me in what way should I use datestr or datevec to get the output something like
Origin Date (Local) Origin Time (Local)

Answers (1)

Supreeth Subbaraya
Supreeth Subbaraya on 6 Aug 2014
To obtain an output like you mentioned, you can use the following code.
DateVector = [Year Month Day Hour Minute Second]
formatOut = 'mm/dd/yyyy HH:MM:SS.FFF'
datestr(DateVector,formatOut)
  2 Comments
KRUNAL
KRUNAL on 6 Aug 2014
I know the code format. But I want to know 2 things from you.. 1st, writing DateVector = [Year Month Day Hour Minute Second] will it access year, month,day,hour,minute and Second columns in a loop? 2nd, if not i think you have not understood my question properly. I want mm/dd/yyyy in 1st column i.e Origin Date (Local) and hh:mm:ss in 2nd column i.e Origin Time (Local)
Can it be done?
KRUNAL
KRUNAL on 7 Aug 2014
Edited: KRUNAL on 7 Aug 2014
I am trying to the following thing :
datecol(:,1) =(ofile(:,3)*1000000) + (ofile(:,4)*10000)+ (ofile(:,2));
formatOut = 'mmm.dd.yyyy';
a=datestr(datecol,formatOut)
It gives me output as:
a = Sep.3.6706
Instead of
a = Jun.10.2014
P. S : "ofile" is the filename where my above 10x7 data is stored.
Can you tel me what is wrong in the above code?

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!