Influxdb is hosted on US region (timezone UTC),. we are forwarding data from 3 regions US, ASIAPAC and EMEA(each in respective timezones) on separate databases in influxdb.
US and ASIAPAC database are returning data on below query, where as EMEA database isn’t.
"select * from Ping where time > now() - 1h "
On each DB i ran below query:
"select * from Ping ORDER BY DESC LIMIT 1 "
Here is the time i capture:
US : 2017-06-08T07:12:06Z "US"
ASIAPAC : 2017-06-08T07:11:04Z "SG"
EMEA : 2017-06-07T23:04:33Z “pl” “$HOSTGROUPNAME$”
For US/ASIAPAC - time captured is UTC time, but for EMEA its UTC-8hrs.
I have no idea, how to capture EMEA data under UTC timezone.
please suggest on how to proceed further.