MATLAB: Converting cell array to matlab datetime format

datetime format

Hi,

I have a cell array with dates like this '03.08.2003 23:00:00.000 GMT+0200'

I want the cell array to be converted to a datetime array. Has anyone got a suggestion for that?

Best Answer

we can replace the gmt with utc

t = {'03.08.2003 23:00:00.000 GMT+0200'};
t = strrep(t,'GMT','UTC');
t = datetime(t,'InputFormat','dd.MM.uuuu HH:mm:ss.SSS ZZZZZ','TimeZone','UTC');
t.TimeZone = '+02:00';

Related Solutions

MATLAB: Can’t convert a cell array to a date using cellfun(@datenum or @datetime)

You do not need to use cellfun to convert your cell array to datetime, but you do need to specify the format of your input string, and since you've got a timezone specified, which timezone you want the datetime in:

c = {'2012-03-12 00:00:00 UTC'
'2010-09-06 00:00:00 UTC'
'2010-10-24 00:00:00 UTC'
'2010-09-06 00:00:00 UTC'
'2012-02-06 00:00:00 UTC'
'2010-09-06 00:00:00 UTC'
'2012-05-22 00:00:00 UTC'
'2011-09-23 00:00:00 UTC'
'2011-06-21 00:00:00 UTC'
'2012-05-30 00:00:00 UTC'
'2012-05-31 00:00:00 UTC'
'2010-10-15 00:00:00 UTC'};
d = datetime(c, 'InputFormat', 'yyyy-MM-dd HH:mm:ss z', 'TimeZone', 'UTC')

The same using cellfun (which as stated is completely unnecessary):

d = cellfun(@(s) datetime(s, 'InputFormat', 'yyyy-MM-dd HH:mm:ss z', 'TimeZone', 'UTC'), c, 'UniformOutput', false);
d = vertcat(d{:})

MATLAB: Convert excel date to datetime

The format has to match exactly.

Both of these work:

S.textdata = '20-Nov-18 12:00:00 PM GMT';
d1 = datetime(S.textdata(1:end-4), 'InputFormat', 'dd-MM-yy hh:mm:ss a', 'TimeZone', 'UTC')
d2 = datetime(S.textdata, 'InputFormat', 'dd-MM-yy hh:mm:ss a ''GMT''', 'TimeZone', 'UTC')

producing:

d1 = 
  datetime
   20-Nov-2018 12:00:00
d2 = 
  datetime
   20-Nov-2018 12:00:00

Experiment to get the result you want.

Best Answer

Related Solutions

MATLAB: Can’t convert a cell array to a date using cellfun(@datenum or @datetime)

MATLAB: Convert excel date to datetime

Related Question