MATLAB Answers

Date and Hour Vector extraction

1 view (last 30 days)
hdiba
hdiba on 24 Apr 2016
Answered: Arnab Sen on 29 Apr 2016
Hi everybody! I have a vector of doubles representing date and hour. Example
DateTime=[207199500
207199501
207199502
207199503
207199504
207199505...]
now i would like to convert it into a date vector and vector with hour values. Example for first entry: 20-07-1995 and 01:00. Can someone help? thanks
  2 Comments
hdiba
hdiba on 24 Apr 2016
it is 02-11-1995(date) and 02:00 (hour). the month value is always 2 numbers. for january till september 01-09.

Sign in to comment.

Answers (1)

Arnab Sen
Arnab Sen on 29 Apr 2016
Hi hdiba,
For a sample datetime you can compute as following script. The same script should work for a Date Time vector as well.
>> dt=207199501
>> Time=mod(dt,100);
>> dt=floor(dt/100);
>> Year=mod(dt,10^4);
>>dt=floor(dt/10^4);
>>month=mod(dt,100);
>>day=floor(dt/100);

Community Treasure Hunt

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

Start Hunting!