This project has moved and is read-only. For the latest updates, please go here.

CSV file Output_help to decode Time stamp reading

Feb 6, 2015 at 8:16 PM

I was successfully able to connect PMU data stream in OpenPDC manager. it is now storing data in SQLserver database. Now I tried to export data in "CSV" file format in local folder. It is exporting the data. But I have some queries as mentioned below:
  1. It has a time stamping column, but its value is somewhat unreadable. For one sample it is showing " 621355968000000000". Can anybody tell me how to decode time from this value.
  2. Secondly I want to use this csv file for post porcessing by matlab in near real-time. Can you suggest me is it good way to work or there are alternatives. Thanks.
Partial view of CSV file:
Signal ID,Measurement Key,Timestamp,Value
Feb 6, 2015 at 8:55 PM
Hello hvpulok,

It looks like the timestamps are in ticks, which are defined as 100-nanosecond intervals since midnight on January 1, 0001. The number of 100-nanosecond intervals between the Ticks epoch and the UNIX epoch is 621355968000000000. If you subtract that and then divide by 10000000, you will have a UNIX timestamp. If you used the AdoOutputAdapter to write the data to SQL Server, there should be a timestampFormat parameter in the connection string that will enable you to export the timestamp in a more human-readable format.

As for MATLAB, I've never worked with it, personally. I'll have to defer that question to someone else.