This project has moved. For the latest updates, please go here.

CSV file Output_help to decode Time stamp reading

Feb 6, 2015 at 7:16 PM
Hello,

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
4dec770a-a6df-4338-a0c4-5760a0516386,PPA:371,621355968000000000,-90.828056976248
9b3b1a8b-f690-4603-96b9-c1ddded51341,PPA:370,621355968000000000,8080.58899707992
848efffe-cb50-4f02-b1b4-51e3fb9cbc0a,PPA:373,621355968000000000,89.1094197788002
16ba7edf-a0ad-44d6-a679-18fe2653fa83,PPA:372,621355968000000000,33.270422220389
8da1fb91-3d96-4a5a-8dbb-2759259da24c,PPA:1011,621355968000000000,-94.8173607176914
Coordinator
Feb 6, 2015 at 7: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.

Thanks,
Stephen