{"action":"created","issue":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/476","labels_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/476/labels{/name}","comments_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/476/comments","events_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/476/events","html_url":"https://github.com/pgjdbc/pgjdbc/pull/476","id":124210244,"number":476,"title":"feat: Implement JSR-310 support in setObject","user":{"login":"marschall","id":471021,"avatar_url":"https://avatars.githubusercontent.com/u/471021?v=3","gravatar_id":"","url":"https://api.github.com/users/marschall","html_url":"https://github.com/marschall","followers_url":"https://api.github.com/users/marschall/followers","following_url":"https://api.github.com/users/marschall/following{/other_user}","gists_url":"https://api.github.com/users/marschall/gists{/gist_id}","starred_url":"https://api.github.com/users/marschall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marschall/subscriptions","organizations_url":"https://api.github.com/users/marschall/orgs","repos_url":"https://api.github.com/users/marschall/repos","events_url":"https://api.github.com/users/marschall/events{/privacy}","received_events_url":"https://api.github.com/users/marschall/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-12-29T13:23:06Z","updated_at":"2015-12-30T13:29:49Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/pulls/476","html_url":"https://github.com/pgjdbc/pgjdbc/pull/476","diff_url":"https://github.com/pgjdbc/pgjdbc/pull/476.diff","patch_url":"https://github.com/pgjdbc/pgjdbc/pull/476.patch"},"body":"JSR-310 support is currently missing in both setObject methods in\r\nPgPreparedStatement.\r\n\r\nImplement JSR-310 support in PreparedStatement.setObject"},"comment":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/comments/167998931","html_url":"https://github.com/pgjdbc/pgjdbc/pull/476#issuecomment-167998931","issue_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/476","id":167998931,"user":{"login":"davecramer","id":406518,"avatar_url":"https://avatars.githubusercontent.com/u/406518?v=3","gravatar_id":"","url":"https://api.github.com/users/davecramer","html_url":"https://github.com/davecramer","followers_url":"https://api.github.com/users/davecramer/followers","following_url":"https://api.github.com/users/davecramer/following{/other_user}","gists_url":"https://api.github.com/users/davecramer/gists{/gist_id}","starred_url":"https://api.github.com/users/davecramer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davecramer/subscriptions","organizations_url":"https://api.github.com/users/davecramer/orgs","repos_url":"https://api.github.com/users/davecramer/repos","events_url":"https://api.github.com/users/davecramer/events{/privacy}","received_events_url":"https://api.github.com/users/davecramer/received_events","type":"User","site_admin":false},"created_at":"2015-12-30T13:29:49Z","updated_at":"2015-12-30T13:29:49Z","body":"I'm coming into this late, but I suspect the issue is that you have to use\na known timezone for tests because when I run them the default will be -5.\nBy specifying it we control it.\n\nDave Cramer\n\nOn 30 December 2015 at 07:40, Philippe Marschall <notifications@github.com>\nwrote:\n\n> Yes the information what the offset was is thrown away and replaced by the\n> default offset, however according to 8.5.1.3. Time Stamps\n> <http://www.postgresql.org/docs/9.4/static/datatype-datetime.html#AEN5989>\n> the backend will to this anyway\n>\n> For timestamp with time zone, the internally stored value is always in UTC\n> (Universal Coordinated Time, traditionally known as Greenwich Mean Time,\n> GMT). An input value that has an explicit time zone specified is converted\n> to UTC using the appropriate offset for that time zone.\n>\n> It is important to note that when the offset is replaced with the default\n> offset it remains the same instant even if that means changing the local\n> date time.\n>\n> To give you an example. Let's say you're in UTC+2 (default time zone) and\n> you want to store 2015-12:30T13:34:00+01:00. Converting it to a\n> java.sql.Timestamp will change this to 2015-12:30T14:34:00+02:00. In the\n> end the backend will store it as `2015-12:30T12:34:00Z.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/pgjdbc/pgjdbc/pull/476#issuecomment-167990682>.\n>\n"}}