DateTime conversion from Table Column

6 views (last 30 days)
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.

Accepted Answer

Star Strider
Star Strider on 17 Sep 2020
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 Comment
Star Strider
Star Strider on 17 Sep 2020
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

Sign in to comment.

More Answers (2)

Djamil Boulahbal
Djamil Boulahbal on 17 Sep 2020
@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 Comment
Star Strider
Star Strider on 17 Sep 2020
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.

Sign in to comment.


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

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!