1 of 1 people found this helpful
Currently, PI JDBC Driver has a limitation against time zone. By default, the time literals are interpreted at the PI SQL DAS server node. According to its user guide,
Time Zone/DST settings must be the same for the PI SQL DAS computer and the PI JDBC Driver client computer. Moreover, the PI OLEDB-specific connection property Time Zone cannot be used. If specified, the setting has no effect.
So if your PI SQL DAS server and PI JDBC Driver are installed in a different time zone, then above limitation can be troublesome.
One workaround is to show the _utctime column for a returned dataset from PI by adding "Show Hidden Metadata = True" initialization property into the connection string. Hopely this will clear up some confusion around what time I am passing to my PI Data/Asset servers.
I hope this helps.