Date Functions available in PI OLEDB Enterprise 2010

Discussion created by RAtkinson on Jul 28, 2010
Latest reply on Jul 29, 2010 by RAtkinson

I have an attribute that contains a time offset (in seconds).  I need to take this integer value and and add it to the timestamp to get an adjusted time.  For example, if the data is:


Timestamp: 27-Jul-2010 08:00:00


Value: -3


I want to return an adjusted timestamp of 27-Jul-2010 07:59:57. 


Are there any Date functions available in PI OLEDB Enterprise that would allow me to perform this calculation?