AnsweredAssumed Answered

Need to change the default timezone in JDBC

Question asked by kstone84 on Feb 6, 2019
Latest reply on Feb 7, 2019 by jyi

I am pulling the PI data through PI JDBC in a select statement
like below:

Select  * from piarchive.piinterp

WHERE tag = 'YYYYYYYYYY'

AND time between ‘1/1/2019 00:00:00’ and ‘1/2/2019 00:00:00’

AND timestep = '1h'

order by time;

 

Is it possible to specify the time zone that I pass to the time
in the where clause?  Is there an example to show how to pass utc to
retrieve the data?

Outcomes