MATLAB: Convert datetime that’s not in Matlab format to a matlab format datetime

convertdatetime

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'?

Best Answer

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.
Related Question