Problems using "datetime" cont.

1 次查看（过去 30 天）
Andy Wileman
Andy Wileman 2021-3-17
评论： 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')

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

采纳的回答

Stephen23
Stephen23 2021-3-17
编辑：Stephen23 2021-3-17
Ran in:
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更早的评论
Stephen23
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
Andy Wileman 2021-3-17
I think they are trailing seconds, as the data is from data aquisition. Once again, thanks.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by