DateTime conversion from Table Column

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.

[Asad (Mehrzad) Khoddam]

Is it Unix time stamp? or simply ticks

Answer 1

[Star Strider]

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

[Star Strider]

My pleasure!

If my Answer helped you solve your problem, please Accept it!

.

Answer 2

[Djamil Boulahbal]

@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.

[Star Strider]

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.

Answer 3

[Djamil Boulahbal]

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