How to convert table with datetime in numeric (seconds)
显示 更早的评论
I want to convert a table ('Zeitt' 1000x1 table) with the format 'dd-mmm-yyyy HH:mm:ss.SSS' (ist that right?) like '15-Jul-2022 12:12:43.086' into a number (seconds that passed by since the first date)
I tried many differnt commands, but still got errors, f.e.:
Zeit = datetime(Zeitt, 'InputFormat', 'dd-mmm-yyyy HH:mm:ss.SSS');
or
Zeit=datenum(Zeitt,'dd-mmm-yy HH:mm:ss.SSS',2021);
or
Zeit=convertTo (Zeitt,'.net');
采纳的回答
Abderrahim. B
2022-7-18
Hi!
Try this:
load Zeitt.mat
time_sec = seconds(Zeitt.Time - Zeitt.Time(1))
Hope this helps
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
