How to import Datetime Format form Database (Microsoft Access)
显示 更早的评论
Hello, when importing a tabel from my Database, the Datetimeformate is converted to cell array of character vectors. I conected via ODCB to my Database. Is there a way how I can import the data format correctly or how I can change it in matlab?
采纳的回答
Tony Mohan Varghese
2018-3-22
Change the date in MATLAB, once it is imported using the datetime and readtable command.
% Code for reading the date from the input file
>> T = readtable('<filename>','Delimiter', '|');
>> T.Var3 = datetime(T.Var3,'InputFormat','yyyy-MM-dd HH:mm:ss.SSSSSSSSS','Format','dd/MMM/yyy HH:mm:ss.SSS');
Use the input format specifier to specify the format of the date strings.
Reference:
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
