Date and Hour Vector extraction

2 views (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);

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!