Convert data table to datetime

Question

0 个投票

I have data shown in the image.

I want to convert the second row into a datetime vector, but InputFormat doesn't work.

It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.

I tried datetime( BLA,'InputFormat','yyyyMMddHHmm')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Adam Danz 2021-5-5

编辑：Adam Danz 2021-5-6

0 个投票

> It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.

x = 201401010000;
dt =  datetime(string(x),'InputFormat','yyyyMMddHHmm')
dt = datetime
   01-Jan-2014

The 'format' property specifies the output format.

x can be a column of values.

Adam Danz 2021-5-6

> I want to convert the second row into a datetime vector

> I would like to e.g. convert it to a timetable

Those are two very different questions.

I've updated my answer. After converting the column to datetime use

Raphael Willi 2021-5-6

Aha, I got it now thanks. I did it with

 TT = table2timetable(data(:,3),'RowTimes',datetime(string(data{:,2}),'InputFormat','yyyyMMddHHmm'));