Change data type of a table column into datetime?

46 次查看（过去 30 天）
Julozert
Julozert 2020-5-27
评论： Mohammad Zaheer Hussein Suhabuth 2022-10-21
Hi,
I have read a table with readtable and changed my the column with the time data to a char using detectImportOptions-function.
I now wanna change the data type from char to datetime but it doesnt work. How do i need to do it?

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

回答（2 个）

Eric Sofen
Eric Sofen 2020-6-9
Take a look at the convertvars function for changing the data type of a table variable.
Also, is there a reason you're bring in the time data as char rather than directly as datetime or duration from readtable?
Drishti Jain
Drishti Jain 2020-5-28
You can use datetime: https://in.mathworks.com/help/matlab/ref/datetime.html
e.g-
tm='10:14:25'
new_tm= datetime(tm,'Format','HH:mm:ss')

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by