Time deadband - query 2
- Last UpdatedFeb 07, 2025
- 1 minute read
This query specifies to only return data that changed during a 4900 millisecond time deadband.
SELECT DateTime, TagName, Value
FROM History
WHERE TagName = 'SysTimeSec'
AND DateTime >= '2001-12-09 11:35'
AND DateTime <= '2001-12-09 11:37'
AND wwRetrievalMode = 'Delta'
AND wwTimeDeadband = 4900
The results are:
|
DateTime |
TagName |
Value |
|
2001-12-09 11:35:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:35:05.000 |
SysTimeSec |
5 |
|
2001-12-09 11:35:10.000 |
SysTimeSec |
10 |
|
2001-12-09 11:35:15.000 |
SysTimeSec |
15 |
|
2001-12-09 11:35:20.000 |
SysTimeSec |
20 |
|
2001-12-09 11:35:25.000 |
SysTimeSec |
25 |
|
2001-12-09 11:35:30.000 |
SysTimeSec |
30 |
|
2001-12-09 11:35:35.000 |
SysTimeSec |
35 |
|
2001-12-09 11:35:40.000 |
SysTimeSec |
40 |
|
2001-12-09 11:35:45.000 |
SysTimeSec |
45 |
|
2001-12-09 11:35:50.000 |
SysTimeSec |
50 |
|
2001-12-09 11:35:55.000 |
SysTimeSec |
55 |
|
2001-12-09 11:36:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:36:05.000 |
SysTimeSec |
5 |
|
2001-12-09 11:36:10.000 |
SysTimeSec |
10 |
|
2001-12-09 11:36:15.000 |
SysTimeSec |
15 |
|
2001-12-09 11:36:20.000 |
SysTimeSec |
20 |
|
2001-12-09 11:36:25.000 |
SysTimeSec |
25 |
|
2001-12-09 11:36:30.000 |
SysTimeSec |
30 |
|
2001-12-09 11:36:35.000 |
SysTimeSec |
35 |
|
2001-12-09 11:36:40.000 |
SysTimeSec |
40 |
|
2001-12-09 11:36:45.000 |
SysTimeSec |
45 |
|
2001-12-09 11:36:50.000 |
SysTimeSec |
50 |
|
2001-12-09 11:36:55.000 |
SysTimeSec |
55 |
|
2001-12-09 11:37:00.000 |
SysTimeSec |
0 |