How to convert one column from string to datetime

13 次查看（过去 30 天）
Manny
Manny 2024-2-18
评论： Dyuman Joshi 2024-2-18
Hi everyone
I have a n by 3 matrix. The second column is date in string format. I need to convert the second column to datetime format "YYYY-MM-DD" and return the other 2 columns untouched. I thought this would work but I am getting an error:
ABC(:,2) = datetime(ABC(:,2));
The error is:
Error using datetime
Input data must be a numeric array, a string array, a cell array containing character vectors,
or a char matrix.
How can I fix my code?
Thank you
  4 个评论
显示 2更早的评论
Manny
Manny 2024-2-18
编辑：Manny 2024-2-18
@Stephen23, thanks for the reply. I am new to Matlab. I am not really sure what you mean/need. Are you asking for this? The problem is CIV table.
Dyuman Joshi
Dyuman Joshi 2024-2-18
Save the table as an excel file using writetable and upload it here using the paperclip button.

请先登录，再进行评论。

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

采纳的回答

Dyuman Joshi
Dyuman Joshi 2024-2-18
Ran in:
If you are using R2018b or a later version, you can use convertvars -
%Random data for example
ABC = table(rand(5,1), {'2014-06-03';'2014-06-11';'2014-06-19';'2014-06-25';'2014-06-26'})
ABC = 5×2 table
Var1 Var2 ________ ______________ 0.018163 {'2014-06-03'} 0.91476 {'2014-06-11'} 0.90892 {'2014-06-19'} 0.11466 {'2014-06-25'} 0.94165 {'2014-06-26'}
%Convert the 2nd column data to datetime
ABC = convertvars(ABC, 2, @(x) datetime(x, 'InputFormat', 'yyyy-MM-dd'))
ABC = 5×2 table
Var1 Var2 ________ ___________ 0.018163 03-Jun-2014 0.91476 11-Jun-2014 0.90892 19-Jun-2014 0.11466 25-Jun-2014 0.94165 26-Jun-2014

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by