Specify Negative Time Offsets in SQL Commander
Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as:
SELECT time, (time - 1d) as datekey
This query works
SELECT time, (time + 1d) as datekey
A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms.
SELECT time, DATEADD(day, -1, time) as datekey
Thank you for your feedback. Unfortunately, this feature is not a priority at time, so I am setting the status to declined.