Resolution - query example
- Last UpdatedFeb 07, 2025
- 1 minute read
The following query returns rows that are spaced at 2 sec (2000 msec) intervals over the requested time period. Data is retrieved cyclically.
SELECT DateTime, TagName, Value
FROM History
WHERE TagName IN ('SysTimeMin','SysTimeSec')
AND DateTime >= '2001-12-09 11:35'
AND DateTime <= '2001-12-09 11:36'
AND wwRetrievalMode = 'Cyclic'
AND wwResolution = 2000
The results are:
|
DateTime |
TagName |
Value |
|
2001-12-09 11:35:00.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:35:02.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:02.000 |
SysTimeSec |
2 |
|
2001-12-09 11:35:04.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:04.000 |
SysTimeSec |
4 |
|
2001-12-09 11:35:06.000 |
SysTimeMin |
35 |
|
... |
||
|
2001-12-09 11:35:54.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:54.000 |
SysTimeSec |
54 |
|
2001-12-09 11:35:56.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:56.000 |
SysTimeSec |
56 |
|
2001-12-09 11:35:58.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:58.000 |
SysTimeSec |
58 |
|
2001-12-09 11:36:00.000 |
SysTimeMin |
36 |
|
2001-12-09 11:36:00.000 |
SysTimeSec |
0 |