The Epoch time is in the t_stamp column of the history tables.
The issue is the built in functions for gathering the data doesn’t have any way to specify the client time zone.
So the interface just assumes the TZ of the WebDev gateway and returns the data in CST.
I can always massage the returned datasets and modify each record before returning it to the requesting system(s) but that ends up with a bunch more custom code.
But it doesn’t. The java.util.Date and java.sql.Timestamp datatypes that end up in datasets are themselves UTC. They don’t have an associated timezone at all. You get the effect of a timezone at the point where they are turned into strings. If Perspective, this is the gateway. Vision projects can be told to assume a particular time zone, so stringification there uses that one.
I understand that, WebDev acts like Perspective in regards to the “client” timezone conversion of data.
Maybe I need to put this in a feature request against system.tag.queryTagHistory since it is always recommended to purchase and use WebDev when you need to feed data to other systems.
Won’t be possible. Datasets from this function contain java.util.Date objects that don’t have a timezone. You have to do it yourself when stringifying the result for the WebDev output. Presuming you know the target timezone, use this procedure: