How to import Datetime Format form Database (Microsoft Access)

Question

Jennifer Pichl 2018-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388458-how-to-import-datetime-format-form-database-microsoft-access

回答： Tony Mohan Varghese 2018-3-22

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?

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

请先登录，再进行评论。

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

Answer 1

Tony Mohan Varghese 2018-3-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388458-how-to-import-datetime-format-form-database-microsoft-access#answer_311305

在 MATLAB Online 中打开

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');