Date and Hour Vector extraction

2 visualizzazioni (ultimi 30 giorni)
hdiba
hdiba il 24 Apr 2016
Risposto: Arnab Sen il 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 Commenti
Azzi Abdelmalek
Azzi Abdelmalek il 24 Apr 2016
What about 211199502? is it 21-01-1995 or 02-11-1995?
hdiba
hdiba il 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.

Accedi per commentare.

Risposte (1)

Arnab Sen
Arnab Sen il 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);

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!

Translated by