{"action":"created","issue":{"url":"https://api.github.com/repos/upper/db/issues/64","labels_url":"https://api.github.com/repos/upper/db/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/upper/db/issues/64/comments","events_url":"https://api.github.com/repos/upper/db/issues/64/events","html_url":"https://github.com/upper/db/pull/64","id":60535292,"number":64,"title":"Refactor postgresql and sql utils packages, using sqlx as underlying lib","user":{"login":"pkieltyka","id":18831,"avatar_url":"https://avatars.githubusercontent.com/u/18831?v=3","gravatar_id":"","url":"https://api.github.com/users/pkieltyka","html_url":"https://github.com/pkieltyka","followers_url":"https://api.github.com/users/pkieltyka/followers","following_url":"https://api.github.com/users/pkieltyka/following{/other_user}","gists_url":"https://api.github.com/users/pkieltyka/gists{/gist_id}","starred_url":"https://api.github.com/users/pkieltyka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkieltyka/subscriptions","organizations_url":"https://api.github.com/users/pkieltyka/orgs","repos_url":"https://api.github.com/users/pkieltyka/repos","events_url":"https://api.github.com/users/pkieltyka/events{/privacy}","received_events_url":"https://api.github.com/users/pkieltyka/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"xiam","id":385670,"avatar_url":"https://avatars.githubusercontent.com/u/385670?v=3","gravatar_id":"","url":"https://api.github.com/users/xiam","html_url":"https://github.com/xiam","followers_url":"https://api.github.com/users/xiam/followers","following_url":"https://api.github.com/users/xiam/following{/other_user}","gists_url":"https://api.github.com/users/xiam/gists{/gist_id}","starred_url":"https://api.github.com/users/xiam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xiam/subscriptions","organizations_url":"https://api.github.com/users/xiam/orgs","repos_url":"https://api.github.com/users/xiam/repos","events_url":"https://api.github.com/users/xiam/events{/privacy}","received_events_url":"https://api.github.com/users/xiam/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2015-03-10T17:16:52Z","updated_at":"2015-03-15T13:01:43Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/upper/db/pulls/64","html_url":"https://github.com/upper/db/pull/64","diff_url":"https://github.com/upper/db/pull/64.diff","patch_url":"https://github.com/upper/db/pull/64.patch"},"body":"..with support for latest pq driver"},"comment":{"url":"https://api.github.com/repos/upper/db/issues/comments/80999466","html_url":"https://github.com/upper/db/pull/64#issuecomment-80999466","issue_url":"https://api.github.com/repos/upper/db/issues/64","id":80999466,"user":{"login":"pkieltyka","id":18831,"avatar_url":"https://avatars.githubusercontent.com/u/18831?v=3","gravatar_id":"","url":"https://api.github.com/users/pkieltyka","html_url":"https://github.com/pkieltyka","followers_url":"https://api.github.com/users/pkieltyka/followers","following_url":"https://api.github.com/users/pkieltyka/following{/other_user}","gists_url":"https://api.github.com/users/pkieltyka/gists{/gist_id}","starred_url":"https://api.github.com/users/pkieltyka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkieltyka/subscriptions","organizations_url":"https://api.github.com/users/pkieltyka/orgs","repos_url":"https://api.github.com/users/pkieltyka/repos","events_url":"https://api.github.com/users/pkieltyka/events{/privacy}","received_events_url":"https://api.github.com/users/pkieltyka/received_events","type":"User","site_admin":false},"created_at":"2015-03-15T13:01:42Z","updated_at":"2015-03-15T13:01:42Z","body":"Great catch!!\n\n\n> On Mar 15, 2015, at 8:52 AM, Carlos Nieto <notifications@github.com> wrote:\n> \n> Got it!\n> \n> According to http://www.postgresql.org/docs/9.4/static/datatype-datetime.html\n> \n> All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the TimeZone configuration parameter before being displayed to the client.\n> \n> And the docs for the TimeZone parameter say:\n> \n> [TimeZone] Sets the time zone for displaying and interpreting time stamps. The built-in default is GMT, but that is typically overridden in postgresql.conf; initdb will install a setting there corresponding to its system environment. See Section 8.5.3 for more information.\n> \n> So that was the reason.\n> \n> upperio_tests=> truncate table data_types;\n> TRUNCATE TABLE\n> upperio_tests=> set timezone = 'Canada/Eastern';\n> SET\n> upperio_tests=> INSERT INTO \"data_types\" (_date) values('2011-07-28 01:02:03-04');\n> INSERT 0 1\n> upperio_tests=> select * from data_types;\n> upperio_tests=> select _date from data_types;\n>          _date          \n> ------------------------\n>  2011-07-28 01:02:03-04\n> (1 row)\n> \n> upperio_tests=> \n> I'll modify the tests accordingly.\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n"}}