Wonderware SQL scripts

rhoke

Member
R
Join Date
Mar 2009
Location
Houston
Posts
1
Hello,

I have an Intouch 9.5 standalone application logging its events to a local SQL database on each machine in a workgroup. The time/date is displayed in the Intouch controls as local but the event timestamp is saved as UTC.

I want to simultaneously create an additional field with the adjusted local time for each time stamp. I need this for a 3rd party SQL reporting utility to display (print)groups of events in the local time.

I am new to SQL access manager and wonderware script. How can I accomplish this?

Robert
 

Similar Topics

W
Wonderware and SQL
1. Why Wonderware crash after SQL crashes. Can I get something official of AVEVA?
Replies
1
Views
1,058
ynpmoose
Y
X
Get column from SQL server to wonderware
I’m trying to get data from a column in sql server to post in wonderware. My select script is as follows...
Replies
8
Views
4,561
Gabriel B. C.
G
T
Wonderware Intouch SQL Access Manager
I have a wonderware standalone HMI collecting process data from our production line. I am writing those values to a database in MySQL, though I...
Replies
0
Views
2,754
tgulch
T
C
SQL Data Display Wonderware
I am new to Wonderware and am trying to display a few columns of information from an SQL database onto one of my HMI screens. The SQL database...
Replies
1
Views
3,364
gclshortt
gclshortt
G
WonderWare/OBDC/SQL
This is a pretty general question since I'm just beginning on these fronts, but does anyone know of a good "Where to Start" type of tutorial? I...
Replies
1
Views
1,927
gclshortt
gclshortt
Back
Top Bottom