Time deadband - query 3
- Last UpdatedFeb 07, 2025
- 1 minute read
This query specifies to only return data that changed during a 2000 millisecond time deadband.
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'
AND wwTimeDeadband = 2000
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:03.000 |
SysTimeSec |
3 |
|
2001-12-09 11:35:06.000 |
SysTimeSec |
6 |
|
2001-12-09 11:35:09.000 |
SysTimeSec |
9 |
|
2001-12-09 11:35:12.000 |
SysTimeSec |
12 |
|
2001-12-09 11:35:15.000 |
SysTimeSec |
15 |
|
2001-12-09 11:35:18.000 |
SysTimeSec |
18 |
|
2001-12-09 11:35:21.000 |
SysTimeSec |
21 |
|
2001-12-09 11:35:24.000 |
SysTimeSec |
24 |
|
2001-12-09 11:35:27.000 |
SysTimeSec |
27 |
|
2001-12-09 11:35:30.000 |
SysTimeSec |
30 |
|
2001-12-09 11:35:33.000 |
SysTimeSec |
33 |
|
2001-12-09 11:35:36.000 |
SysTimeSec |
36 |
|
2001-12-09 11:35:39.000 |
SysTimeSec |
39 |
|
2001-12-09 11:35:42.000 |
SysTimeSec |
42 |
|
2001-12-09 11:35:45.000 |
SysTimeSec |
45 |
|
2001-12-09 11:35:48.000 |
SysTimeSec |
48 |
|
2001-12-09 11:35:51.000 |
SysTimeSec |
51 |
|
2001-12-09 11:35:54.000 |
SysTimeSec |
54 |
|
2001-12-09 11:35:57.000 |
SysTimeSec |
57 |
|
2001-12-09 11:36:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:36:00.000 |
SysTimeMin |
36 |