Delta retrieval - query 2
- Last UpdatedFeb 05, 2025
- 1 minute read
SELECT DateTime, TagName, Value
FROM History
WHERE TagName IN ('SysTimeSec','SysTimeMin')
AND DateTime >= '2001-12-09 11:35'
AND DateTime <= '2001-12-09 11:36'
AND wwRetrievalMode = 'Delta'
The results are:
|
DateTime |
TagName |
Value |
|
2001-12-09 11:35:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:35:00.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:01.000 |
SysTimeSec |
1 |
|
2001-12-09 11:35:02.000 |
SysTimeSec |
2 |
|
2001-12-09 11:35:03.000 |
SysTimeSec |
3 |
|
2001-12-09 11:35:04.000 |
SysTimeSec |
4 |
|
... |
||
|
2001-12-09 11:35:58.000 |
SysTimeSec |
58 |
|
2001-12-09 11:35:59.000 |
SysTimeSec |
59 |
|
2001-12-09 11:36:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:36:00.000 |
SysTimeMin |
36 |