MATLAB Answers

Change data type of a table column into datetime?

20 views (last 30 days)
Julozert
Julozert on 27 May 2020
Answered: Eric Sofen on 9 Jun 2020
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?

  0 Comments

Sign in to comment.

Answers (2)

Drishti Jain
Drishti Jain on 28 May 2020
e.g-
tm='10:14:25'
new_tm= datetime(tm,'Format','HH:mm:ss')

  0 Comments

Sign in to comment.


Eric Sofen
Eric Sofen on 9 Jun 2020
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?

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by