Character to date and time
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
Andrei Bobrov
on 15 Aug 2012
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 Comments
Andrei Bobrov
on 15 Aug 2012
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'));
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!