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

Illustration
Saunok Chakrabarty - 2023-04-11T13:04:41+00:00
Question: 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?

Related Questions

  • How do I add a time column in the format of YYYY-MM-DD to my table?
  • Select values based on datetime

    • Expert Answer

    Profile picture of John Williams John Williams answered . 2025-11-20

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

     


    Not satisfied with the answer ?? ASK NOW

    Get a Free Consultation or a Sample Assignment Review!

    Upload Assignment Talk to Expert