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

Technical Source
1 min readApr 11, 2023

--

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?

NOTE:-

Matlabsolutions.com provide latest MatLab Homework Help,MatLab Assignment Help , Finance Assignment Help for students, engineers and researchers in Multiple Branches like ECE, EEE, CSE, Mechanical, Civil with 100% output.Matlab Code for B.E, B.Tech,M.E,M.Tech, Ph.D. Scholars with 100% privacy guaranteed. Get MATLAB projects with source code for your learning and research.

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')

SEE COMPLETE ANSWER CLICK THE LINK

--

--

Technical Source

Simple! That is me, a simple person. I am passionate about knowledge and reading. That’s why I have decided to write and share a bit of my life and thoughts to.