I imported a WFS layer from a geoserver into QGIS and also into a web service that is based on Cesium. The geoserver fetches the data from Elastic search and serves it out as WFS. The date-time attribute of the data stored in Elastic Search is in UTC. The web service (based on Cesium) displays the date-time attribute in UTC, but QGIS displays the same date-time attribute my local time zone. My local time zone is GMT minus 5 hours.
Example: A date-time attribute is stored in Elastic Search as ‘2017-12-29 01:10:37.000Z’. The web service displays the date-time as ‘2017-12-29T01:10:37Z’. The QGIS Identify Results and the QGIS attribute table both display the date-time as ‘2017-12-28T20:10:37’
Including a ‘Z’ in the SQL filter doesn’t seem to make any difference and provides misleading results. In QGIS, the layer filter date-time = ‘2017-12-28 20:10:37.000Z’ finds the feature, but date-time = ‘2017-12-29 01:10:37.000Z’ does not find the feature.
It seems QGIS is converting the date-time attribute to local time. I can’t find a preference to override QGIS converting date-time values. I want the results to be displayed in UTC, not local. Is there a way to do that in QGIS?