DateTime conversion from Table Column

2020 9 17
3 个回答
回答已采纳
更新时间：2020 9 17
4 次查看（30 天）

0 个投票

I have a table (from ASCII file) that has various information in it. The first column is a 'DateTime' and has units of 'ticks'. It is supposed to be a Long Integer, but when loaded in the table, it shows up in scientific notation (double). How do I force that to be an integer, at load time?
Then, the next question is how to convert a DateTime entry into something useful. There is the ConvertTo function in the financial toolbox, but I have no access to it.

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

 采纳的回答

Star Strider
Star Strider 2020-9-17

0 个投票

The datetime function has a 'ConvertFrom' option. For one example, see: Convert Excel Date Number to Datetime There are other options such as 'posixtime'.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Star Strider
Star Strider 2020-9-17
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

请先登录，再进行评论。

更多回答（2 个）

Djamil Boulahbal
Djamil Boulahbal 2020-9-17

0 个投票

@mehrzad - those are ticks, on a WIndows 10 64-Bit laptop
@starstrider - those functions are only available in the financial toolbox, which I do not have. I'm looking for alternatives.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Star Strider
Star Strider 2020-9-17
Those functions are available in core MATLAB.
Click on the link I posted. It will take you to the appropriate section of the datetime. documentation.

请先登录，再进行评论。

Djamil Boulahbal
Djamil Boulahbal 2020-9-17

0 个投票

Thank you very much. I was somehow looking for the convertTo function, and my Matlab version/toolboxes do not have it. Thanks again.

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by