How to convert time in nanosecond to numeric value in order to be able to compare these timeseries?

1 view (last 30 days)
Hello,
I have the number of *.csv files that are same structure (same column number), but row numbers are different. I use readtable to upload data to matlab. I need to compare timeseries of different csv files. The example of timeseries:
'08:34:37.762296992'
'08:34:37.762450580'
'08:34:37.762450580'
'08:34:37.762460422'
'08:34:37.762460422'
'08:34:37.762472108'
'08:34:37.762472108'
'08:34:37.762543205'
'08:34:37.762543205'
'08:34:37.762673812'
How to convert this type to timeseries to numeric value in order to be able to compare them?

Accepted Answer

madhan ravi
madhan ravi on 15 Nov 2018
Edited: madhan ravi on 16 Nov 2018
T=readtable('mycsv.csv')
datetime(T{:,1},'InputFormat','HH:mm:ss.SSS') %highly recommended
  11 Comments
Peter Perkins
Peter Perkins on 15 Nov 2018
Also: these two
datenum(T{:,1})
datevec(T{:,1})
aren't really gonna work correctly, because datenums and datevecs just don't support timestamps to ns resolution.

Sign in to comment.

More Answers (0)

Categories

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

Community Treasure Hunt

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

Start Hunting!