Delta Retrieval - Query 3
- Last UpdatedMar 18, 2021
- 1 minute read
SELECT * FROM OpenQuery(INSQL,'SELECT DateTime, Value, Quality, QualityDetail
FROM AnalogHistory
WHERE TagName = "SysTimeSec"
AND wwRetrievalMode = "Delta"
AND Value = 10
AND DateTime >="2001-07-27 03:00:00.000"
AND DateTime <="2001-07-27 03:05:00.000"
')
The results are:
|
DateTime |
Value |
Quality |
QualityDetail |
|---|---|---|---|
|
2001-07-27 03:00:10.000 |
10 |
0 |
192 |
|
2001-07-27 03:01:10.000 |
10 |
0 |
192 |
|
2001-07-27 03:02:10.000 |
10 |
0 |
192 |
|
2001-07-27 03:03:10.000 |
10 |
0 |
192 |
|
2001-07-27 03:04:10.000 |
10 |
0 |
192 |