{"action":"created","issue":{"url":"https://api.github.com/repos/getredash/redash/issues/1053","repository_url":"https://api.github.com/repos/getredash/redash","labels_url":"https://api.github.com/repos/getredash/redash/issues/1053/labels{/name}","comments_url":"https://api.github.com/repos/getredash/redash/issues/1053/comments","events_url":"https://api.github.com/repos/getredash/redash/issues/1053/events","html_url":"https://github.com/getredash/redash/issues/1053","id":154619017,"number":1053,"title":"Issue with Timezone in Redash AMI 0.10 using Postgresql RDS","user":{"login":"shahneil88","id":7529421,"avatar_url":"https://avatars.githubusercontent.com/u/7529421?v=3","gravatar_id":"","url":"https://api.github.com/users/shahneil88","html_url":"https://github.com/shahneil88","followers_url":"https://api.github.com/users/shahneil88/followers","following_url":"https://api.github.com/users/shahneil88/following{/other_user}","gists_url":"https://api.github.com/users/shahneil88/gists{/gist_id}","starred_url":"https://api.github.com/users/shahneil88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shahneil88/subscriptions","organizations_url":"https://api.github.com/users/shahneil88/orgs","repos_url":"https://api.github.com/users/shahneil88/repos","events_url":"https://api.github.com/users/shahneil88/events{/privacy}","received_events_url":"https://api.github.com/users/shahneil88/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-13T02:07:03Z","updated_at":"2016-05-23T15:37:01Z","closed_at":null,"body":"\r\nI have redash AMI image with version 0.10.0+b1774. I was having sqlite as redash metadata db.\r\nOnce we decided , we can go LIVE with it , I launched a new PostgreSQL RDS and created new DB.\r\n\r\nI created few queries and scheduled it to run at 7:00 AM. When it didn't run on expected time, I realised that, the DB timezone was set to UTC. So, I changed to 'Singapore' (UTC+8)\r\nI went to PostgreSQL RDS and fired a query for timezone and current time. It showed me correct values \r\n\r\nI wen to Redash and fired query to redash metadata. It still shows me UTC time, but shows correct timezone.\r\n\r\nI did a restart all and deleted query results from admin panel to avoid fetching values from cache.\r\nBut still, it shows UTC time and my scheduled query also runs on UTC time.\r\nMy ubuntu image is also on Singapore timezone.\r\n\r\nI am not sure what the issue is and how to debug and resolve it?"},"comment":{"url":"https://api.github.com/repos/getredash/redash/issues/comments/221012708","html_url":"https://github.com/getredash/redash/issues/1053#issuecomment-221012708","issue_url":"https://api.github.com/repos/getredash/redash/issues/1053","id":221012708,"user":{"login":"arikfr","id":71468,"avatar_url":"https://avatars.githubusercontent.com/u/71468?v=3","gravatar_id":"","url":"https://api.github.com/users/arikfr","html_url":"https://github.com/arikfr","followers_url":"https://api.github.com/users/arikfr/followers","following_url":"https://api.github.com/users/arikfr/following{/other_user}","gists_url":"https://api.github.com/users/arikfr/gists{/gist_id}","starred_url":"https://api.github.com/users/arikfr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arikfr/subscriptions","organizations_url":"https://api.github.com/users/arikfr/orgs","repos_url":"https://api.github.com/users/arikfr/repos","events_url":"https://api.github.com/users/arikfr/events{/privacy}","received_events_url":"https://api.github.com/users/arikfr/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T15:37:00Z","updated_at":"2016-05-23T15:37:00Z","body":"I think the reason you had issues is because difference between the database and the server. If they were both set to UTC it would've worked. \r\n\r\nThe way the scheduling dialog works is that it takes input in *user's timezone* and converts it *UTC*. I can only assume that this didn't work as designed for you because of the mismatch in timezones between the server and database. Therefore switching back should have no impact on the end user.\r\n\r\nIf you want to test this, try creating a scheduled query on the [demo instance](https://demo.redash.io/) and let me know the query id and I will tell you what time it got saved with in the database."}}
{"actor":{"display_login":"arikfr"}}