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
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?