How do I add a time column in the format of YYYY-MM-DD to my table?

I have a table containing time series data of some macroeconomic variables. My data is quarterly, starting from 1947-01-01 and ending on 2022-10-01. However, MATLAB is representing these dates numerically - eg, 1947-01-01 shows up as -725846400, after I imported the file into MATLAB from R. How do I change the time column to quarterly data in the range that I want?

Answer 1

[Jon]

I think R stores dates as posix time.

You can use something like this to convert to datetime format eg 31-Dec-1969 23:59:56

d = datetime(-725846400, 'ConvertFrom', 'posixtime')

[Jon]

So if you had a table, let's call it T, with a column of r times with the variable named t you could use:

T.t = datetime(T.t, 'ConvertFrom', 'posixtime')

to convert the column to date time format

[Peter Perkins]

Precisely. But really, you want a timetable. If you have a table with a datetime in it, that's just a metter of calling table2timetable.

[Jon]

Are you all set now, or did you have further questions?

[Saunok Chakrabarty]

Works perfectly. Thanks a lot!

[Jon]

You're welcome