{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb.com/issues/488","labels_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/488/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/488/comments","events_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/488/events","html_url":"https://github.com/influxdb/influxdb.com/issues/488","id":117109498,"number":488,"title":"Incorrect timezone in tag 'time' on version 0.9.4.2","user":{"login":"yonger1516","id":6733760,"avatar_url":"https://avatars.githubusercontent.com/u/6733760?v=3","gravatar_id":"","url":"https://api.github.com/users/yonger1516","html_url":"https://github.com/yonger1516","followers_url":"https://api.github.com/users/yonger1516/followers","following_url":"https://api.github.com/users/yonger1516/following{/other_user}","gists_url":"https://api.github.com/users/yonger1516/gists{/gist_id}","starred_url":"https://api.github.com/users/yonger1516/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yonger1516/subscriptions","organizations_url":"https://api.github.com/users/yonger1516/orgs","repos_url":"https://api.github.com/users/yonger1516/repos","events_url":"https://api.github.com/users/yonger1516/events{/privacy}","received_events_url":"https://api.github.com/users/yonger1516/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-16T12:02:11Z","updated_at":"2015-11-17T03:50:49Z","closed_at":"2015-11-16T15:31:28Z","body":"[root@test201 /opt/influxdb]$ date -R\r\nMon, 16 Nov 2015 19:51:35 +0800\r\n[root@test201 /opt/influxdb]$ ./influx\r\nConnected to http://localhost:8086 version 0.9.4.2\r\nInfluxDB shell 0.9.4.2\r\n> use collectd\r\nUsing database collectd\r\n> select * from cpu_value where host='db201' order by time desc limit 10;\r\nname: cpu_value\r\n---------------\r\ntime\t\t\t\thost\ttype\ttype_instance\tvalue\r\n2015-11-16T11:51:46.081569Z\tdb201\tpercent\tuser\t\t3.3690274907633544\r\n2015-11-16T11:51:36.081638Z\tdb201\tpercent\tuser\t\t2.639809833604406\r\n2015-11-16T11:51:26.081705Z\tdb201\tpercent\tuser\t\t2.593335003758457\r\n2015-11-16T11:51:16.081553Z\tdb201\tpercent\tuser\t\t2.660073856168241\r\n2015-11-16T11:51:06.081548Z\tdb201\tpercent\tuser\t\t2.567474481808504\r\n\r\n========================\r\nMy machine's timezone is CST(UTC+8), but the value of 'time' seems UTC+0, they have 8 hours gap.(db201,test201 are the same machine)"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb.com/issues/comments/157260075","html_url":"https://github.com/influxdb/influxdb.com/issues/488#issuecomment-157260075","issue_url":"https://api.github.com/repos/influxdb/influxdb.com/issues/488","id":157260075,"user":{"login":"yonger1516","id":6733760,"avatar_url":"https://avatars.githubusercontent.com/u/6733760?v=3","gravatar_id":"","url":"https://api.github.com/users/yonger1516","html_url":"https://github.com/yonger1516","followers_url":"https://api.github.com/users/yonger1516/followers","following_url":"https://api.github.com/users/yonger1516/following{/other_user}","gists_url":"https://api.github.com/users/yonger1516/gists{/gist_id}","starred_url":"https://api.github.com/users/yonger1516/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yonger1516/subscriptions","organizations_url":"https://api.github.com/users/yonger1516/orgs","repos_url":"https://api.github.com/users/yonger1516/repos","events_url":"https://api.github.com/users/yonger1516/events{/privacy}","received_events_url":"https://api.github.com/users/yonger1516/received_events","type":"User","site_admin":false},"created_at":"2015-11-17T03:50:49Z","updated_at":"2015-11-17T03:50:49Z","body":"why my query is error?\r\n> select mean(value) from cpu_value where time >= today() group by time(10m) time_zone(PST);\r\nERR: error parsing query: found ), expected SELECT, DELETE, SHOW, CREATE, DROP, GRANT, REVOKE, ALTER, SET at line 1, char 89\r\n\r\nI don't find any guide about 'time_zone' in official docs."}}