Specifying the end date with "<"
- Last UpdatedMar 19, 2025
- 1 minute read
If the end date is specified using < (less than), then the last row returned is the last valid change up to (but not including) the end date. If the end date uses "<" then the last event returned will have a date/time less than the end date. If there is an event exactly at the end date, it will not be returned.
This query uses the remote table view.
SELECT DateTime, Value, Quality
FROM History
WHERE TagName = 'SysTimeMin'
AND wwRetrievalMode = 'Delta'
AND DateTime > '2001-01-13 12:00:30'
AND DateTime < '2001-01-13 12:10:00'
Note that there is a valid change at exactly the end time of the query (12:10:00), but it is excluded from the result set.
|
DateTime |
Value |
Quality |
|
2001-01-13 12:01:00.000 |
1 |
0 |
|
2001-01-13 12:02:00.000 |
2 |
0 |
|
2001-01-13 12:03:00.000 |
3 |
0 |
|
2001-01-13 12:04:00.000 |
4 |
0 |
|
2001-01-13 12:05:00.000 |
5 |
0 |
|
2001-01-13 12:06:00.000 |
6 |
0 |
|
2001-01-13 12:07:00.000 |
7 |
0 |
|
2001-01-13 12:08:00.000 |
8 |
0 |
|
2001-01-13 12:09:00.000 |
9 |
0 |
(9 row(s) affected)