Change data type of a table column into datetime?

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?

Answer 1

[Eric Sofen]

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?

Answer 2

[Drishti Jain]

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

[Mohammad Zaheer Hussein Suhabuth]

How abou the whole column of the table?