Have PI OLEDB work with structured annotations.Hopefully at the very least with String Type annotations.2 votes
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
WHERE tag='sinusoid'1 vote
- Don't see your idea?