AnsweredAssumed Answered

Using decimals in time specification

Question asked by jamesmuri on Sep 25, 2017
Latest reply on Sep 26, 2017 by kduffy

Our organization has recently upgraded to Office 2016 and as part of that we are now using PIODBC 2016 R2 vs. our old version of the driver (1.3.1.0).  I used to be able to pass an SQL query that that looked like this to the PI Server:

 

     SELECT time FROM piinterp WHERE time='*-1.5d' and tag='sinusoid'

 

PIODBC now gives me a conversion error.  If I change the time specification so that it uses only integer values, the query works fine and returns a value.  Does anyone have any ideas about how to get around this?  I am hoping to avoid doing something like specifying everything in minutes to get the time resolution necessary.

 

Thanks

Jim Muri

Outcomes