Date and Hour Vector extraction

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

[Azzi Abdelmalek]

What about 211199502? is it 21-01-1995 or 02-11-1995?

[hdiba]

it is 02-11-1995(date) and 02:00 (hour). the month value is always 2 numbers. for january till september 01-09.

Answer 1

[Arnab Sen]

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);