RAtkinson

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?

Outcomes