Converting Numeric Dates in Matlab does not work

2 次查看（过去 30 天）
Metin Akyol
Metin Akyol 2022-3-3
回答： Steven Lord 2022-3-3
I have a date column in my table with dates in numeric format, e.g. one date might look like this: 738570
When I try to convert it like this:
table1.Date = date(table1.Date)
I get this error:
Error using date Too many input arguments
  2 个评论
Stephen23
Stephen23 2022-3-3
The DATE function does not accept any input arguments:
https://www.mathworks.com/help/matlab/ref/date.html
What do you expect to happen when you call a function with more input arguments than it accepts?
Metin Akyol
Metin Akyol 2022-3-3
Makes sense. I ended up trying that after I got this error with Datetime:
Numeric Input data must be a matrix with three or six columns ....

请先登录，再进行评论。

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

采纳的回答

KSSV
KSSV 2022-3-3
编辑：KSSV 2022-3-3
table1.Date = datestr(table1.Date)
Or
table1.Date = datetime(datevec(table1.Date))

更多回答（1 个）

Steven Lord
Steven Lord 2022-3-3
Ran in:
Another way to do this is to convery the serial date number to a datetime using the 'ConvertFrom' name-value pair argument.
x = 738570;
dt = datetime(x, 'ConvertFrom', 'datenum')
dt = datetime
18-Feb-2022
Let's check, since a datenum is the "Number of days since 0-Jan-0000 (proleptic ISO calendar)."
check = datetime(0, 1, 0) + caldays(x) % x calendar days after 0-Jan-0000
check = datetime
18-Feb-2022

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by