Convert datetime that's not in Matlab format to a matlab format datetime

Question

Rahah Hadri 2019-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459934-convert-datetime-that-s-not-in-matlab-format-to-a-matlab-format-datetime

评论： Rahah Hadri 2019-5-4

Hi, I have a cell array of datetime in a different format that isn't recognised in Matlab's format. Eg : 2014-12-13T18:45:00+00:00 . How do I change this to an acceptable Matlab datetime format ? Like 'yyyy-MM-dd''T''HH:mmXXX'?

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

请先登录，再进行评论。

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

Answer 1

dpb 2019-5-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459934-convert-datetime-that-s-not-in-matlab-format-to-a-matlab-format-datetime#answer_373366

在 MATLAB Online 中打开

TZ offsets are recognized in ML datetime -- your string can be converted as:

s='2014-12-13T18:45:00+00:00';
>> datetime(s,'InputFormat','yyyy-MM-dd''T''HH:mm:ssxxx', ...
              'TimeZone','Europe/London', ...
              'Format','yyyy-MM-dd HH:mm:ss')
ans = 
  datetime
   2014-12-13 18:45:00
>> 

You do have to provide the reference 'TimeZone' named parameter to convert the input date string in a specific time zone; however; once done, if wanted can convert to unzoned time by setting resultant variable 'TimeZone' property to the empty/null string '';

I chose a different display format simply to illustrate...set as desired.