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

3 次查看（过去 30 天）
Saunok Chakrabarty
评论： Jon 2023-4-10
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?

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

采纳的回答

Jon
Jon 2023-4-3
编辑：Jon 2023-4-3
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')
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by