Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

Delta retrieval - query 2

  • Last UpdatedFeb 05, 2025
  • 1 minute read

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'

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:01.000

SysTimeSec

1

2001-12-09 11:35:02.000

SysTimeSec

2

2001-12-09 11:35:03.000

SysTimeSec

3

2001-12-09 11:35:04.000

SysTimeSec

4

...

2001-12-09 11:35:58.000

SysTimeSec

58

2001-12-09 11:35:59.000

SysTimeSec

59

2001-12-09 11:36:00.000

SysTimeSec

0

2001-12-09 11:36:00.000

SysTimeMin

36

TitleResults for “How to create a CRG?”Also Available in