MATLAB: Fraction of a day to HH:MM:SS

datetime formatinput format

Good day everyone.

I have a date, 17037.46688591, and want to convert it to a datetime.

I'm not sure what to include in the datetime InputFormat to allow for the fraction of a day to get the HH:MM:SS.

I can get the date:

inputdate = '17037.46688591';
jday = inputdate(1:5);
date = datetime(jday,'InputFormat','yyDDD')
     date = 06-Feb-2017

How do I get .46688591 into HH:MM:SS?

I've tried a few things but I must be doing something wrong. Thanks for the help.

This would work:

inputdate = '17037.46688591';
jday = inputdate(1:5);
date = datetime(jday, 'InputFormat', 'yyDDD') + days(mod(str2double(inputdate), 1))

assuming that .46688591 is a fraction of a day.

For your first question, you have to use the InputFormat as 'yyMMdd' instead of 'yyMMDD'

datetime(jday,'InputFormat','yyMMdd')

Changing the above InputFormat also helps in correcting the second error as well; and to get the datetime including time values as follows

inputtime = '190608.347009447';
jday = inputtime(1:6);
datetime(jday, 'InputFormat', 'yyMMdd') + days(mod(str2double(inputtime), 1))

I hope this helps to correct the errors and to get the results as expected.

t = datetime(DateStrings,'InputFormat','dd/MM/yyyy');