Change data type of a table column into datetime?

56 visualizzazioni (ultimi 30 giorni)
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?

Risposte (2)

Eric Sofen
Eric Sofen il 9 Giu 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?

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

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by