How to convert datetime to datestr including day of year

Question

Kurt 2022-10-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1835013-how-to-convert-datetime-to-datestr-including-day-of-year

评论： Kurt 2022-10-25

I can convert a date string to a datetime object using datetime(), and convert that object back to a string using datestr(). However, my date includes a three-digit day of year field (day 179, say). I can use formatting to convert the day of year to the correct datetime object by overloading the day of month field, but I see no good way to reverse the process in datestr.

time_string = '22179114244.580';
date_time = datetime(time_string, 'InputFormat',  'uuDDDHHmmss.SSS')
    date_time = 
    datetime 28-Jun-0022 11:42:44        % this is correct so far
    
formatOut = 'yy:ddd:HH:mm:SS.FFF';
datestr(date_time,formatOut)
    ans = 
    '22:Tue:11:06:44.580'                % WRONG

What format must I use to represent the day of year using datestr? Python uses %j to specifically represent the day of year, but I see no equivalent in Matlab.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2022-10-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1835013-how-to-convert-datetime-to-datestr-including-day-of-year#answer_1083243

在 MATLAB Online 中打开

Looking at the table of format identifiers in the description of the Format property of datetime objects on the datetime documentation page, the identifiers D, DD, or DDD will do what you want if you convert the datetime into a string using string. You will also need to use s or ss for whole seconds and S, SS, etc. for fractional seconds.

time_string = '22179114244.580';
date_time = datetime(time_string, 'InputFormat',  'uuDDDHHmmss.SSS')
date_time = datetime
   28-Jun-0022 11:42:44
formatOut = 'yy:D:HH:mm:ss.SSS';
s = string(date_time, formatOut)
s = "22:179:11:42:44.580"

Let's check.

day(date_time, 'dayofyear')
ans = 179

Wikipedia confirms that June 28th is the 179th (or 180th in a leap year) day of the year.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Steven Lord 2022-10-25

在 MATLAB Online 中打开

That's pretty easy. I'm going to use 6 second increments to make it easier to see the effect, but you could use 0.6 second increments.

N = datetime('now')
N = datetime
   25-Oct-2022 19:23:08
sixSecondIncrements = N + seconds(0:6:30).'
sixSecondIncrements = 6×1 datetime array
   25-Oct-2022 19:23:08
   25-Oct-2022 19:23:14
   25-Oct-2022 19:23:20
   25-Oct-2022 19:23:26
   25-Oct-2022 19:23:32
   25-Oct-2022 19:23:38