Problems using "datetime" cont.

Question

Andy Wileman 2021-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775402-problems-using-datetime-cont

评论： Andy Wileman 2021-3-17

Hi,

Having solved problems with getting the current date from a structure into a table (thank you Adam). Using "datetime" still does not seem to be carrying out the conversion. Any thoughts?

Kind regards,

Andy

table
                  Dates              
    _________________________________
    "12/24/2008 9:59:47 AM.786743640"
    
  %Current file format{'12/24/2008 9:59:47 AM.786743640'}
  
  %Fileformat to convert to = data-20130325T004512Z.mat
    
date=cell2mat(dateName);
data=cell2mat(timeDom);
N = date
T = table(string(N), 'VariableNames', {'Dates'})
dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')
% TODO: Save files
   save(data, '-append', '-struct', 'dt');
   
Error using datetime (line 640)
Unable to convert 'T.Dates' to datetime using the format 'yyyyMMdd'T'HHmmss'Z'.
Error in extractor (line 20)
dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775402-problems-using-datetime-cont#answer_650062

编辑：Stephen23 2021-3-17

在 MATLAB Online 中打开

You should probably specify the input format to match the provided string:

S = "12/24/2008 9:59:47 AM.786743640";
D = datetime(S, 'InputFormat','MM/dd/yyyy h:m:s a.SSSSSSSSS')
D = datetime
   24-Dec-2008 09:59:47
D.Format = 'yyyyMMdd''T''HHmmss''Z'''
D = datetime
   20081224T095947Z

You also need to refer to the table, not define a literal character vector:

datetime( T.Dates ,...) % correct way to refert to table T.
datetime('T.Dates',...) % defines a character vector, does not help you.

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

Stephen23 2021-3-17

@Andy Wileman: note that I assumed that the trailing decimal fraction are fractional seconds. If they represent some other data, then you will need to make the required changes.

Andy Wileman 2021-3-17