Character to date and time

Question

Vengatesan 2012-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46056-character-to-date-and-time

I have a series of date & time data as below

      '2012-03-01T00:01:00.000Z'
      '2012-03-01T00:30:59.999Z'
      '2012-03-01T01:00:59.999Z'
      '2012-03-01T01:31:00.000Z'
      '2012-03-01T02:00:59.999Z'
      '2012-03-01T02:29:59.999Z'
      '2012-03-01T03:00:00.000Z'

I would like to remove 'T' and 'Z' and re-write the above into another date/time series of a form (please note a space between date and time):

01/03/2012 00:01:00.000
01/03/2012 00:30:59.999
01/03/2012 01:00:59.999
01/03/2012 01:31:00.000
01/03/2012 02:00:59.000
01/03/2012 02:29:59.999
01/03/2012 03:00:00.000

Any help Thanks.

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2012-8-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46056-character-to-date-and-time#answer_56306

在 MATLAB Online 中打开

A = { '2012-03-01T00:01:00.000Z'
    '2012-03-01T00:30:59.999Z'
    '2012-03-01T01:00:59.999Z'
    '2012-03-01T01:31:00.000Z'
    '2012-03-01T02:00:59.999Z'
    '2012-03-01T02:29:59.999Z'
    '2012-03-01T03:00:00.000Z'}
out = regexprep(A,{'T','Z$'},{' ',''});

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

Vengatesan 2012-8-15

Andrei, Just one more point. I would like to write the date/time as

01/03/2012 00:01:00.000 01/03/2012 00:30:59.999 01/03/2012 01:00:59.999 01/03/2012 01:31:00.000 01/03/2012 02:00:59.000 01/03/2012 02:29:59.999 01/03/2012 03:00:00.000

but your solution gives '2012-03-01 00:01:00.000' '2012-03-01 00:30:59.999' '2012-03-01 01:00:59.999' '2012-03-01 01:31:00.000' '2012-03-01 02:00:59.999' '2012-03-01 02:29:59.999' '2012-03-01 03:00:00.000' Thanks.

Andrei Bobrov 2012-8-15

在 MATLAB Online 中打开

A = {'01/03/2012 00:01:00.000'
'01/03/2012 00:30:59.999'
'01/03/2012 01:00:59.999'
'01/03/2012 01:31:00.000'
'01/03/2012 02:00:59.000'
'01/03/2012 02:29:59.999'
'01/03/2012 03:00:00.000'};
out = cellstr(datestr(datenum(A,'dd/mm/yyyy HH:MM:SS.FFF'),'yyyy-mm-dd HH:MM:SS.FFF'));