Skip to main content
D
drichter1-Visitor
1-Visitor
March 6, 2018
Question

Datetime with microseconds

  • March 6, 2018
  • 2 replies
  • 2804 views

Hi,

 

for a big data project I have the requirement to save 8k datasets per second with a microsecond datetime field. Is there a possibility to save datetime values with microseconds?

2 replies

S
supandey5-Regular Member
5-Regular Member
March 6, 2018

Hi @drichter in what sort of date/time format will the date& time be received within ThingWorx? 

D
drichter1-VisitorAuthor
1-Visitor
March 7, 2018

I'm not 100 sure but the sensor we used generates 8000 datasets per seconds (mean 8 datasets per ms). We will send this "8000 dataset"-package via the sdk to the thingworx server. Probably via a service call which accept a infotable.

 

Ok the normal datetime can not handle microseconds. Which other way can be used? Saving all microseconds since 1.1.1970 in a Long Property?

C
CarlesColl1-Visitor
1-Visitor
March 7, 2018

Well, I don't know if it will be useful, but you can use a Stream with the following format:

 

Timestamp, mix(NUMBER), max(NUMBER), sum(NUMBER),first(NUMBER),last(NUMBER),average(NUMBER), data(JSON)

 

And you just record one resumed data point per millisecond or second with the statistical values, and the detail data it's recorded on the data column as a JSON format for instance.

 

Just an option.

C
CarlesColl1-Visitor
1-Visitor
March 7, 2018

As far as I know, DATETIME fields on ThingWorx max precision it's milliseconds, and you will face a hard limit here as ValueStreams and Streams are indexed/pk by timestamp field, which it's millisecond precision and you wan't be able to record with more precision than that.

Terms & ConditionsAccessibility statement