Specifying the end date with "<="
- Last UpdatedMar 19, 2025
- 1 minute read
If the end date is specified using <= (less than or equal to) then the last row returned is the last valid change up to, and including, the end date. If the end date uses "<=" then the last change returned may have a date/time exactly at the end date. If there is a value exactly at the end date, it will 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):
|
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 |
|
2001-01-13 12:10:00.000 |
10 |
0 |
(10 row(s) affected)