{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/972","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/972/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/972/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/972/events","html_url":"https://github.com/npgsql/npgsql/issues/972","id":131677561,"number":972,"title":"DateTime.UtcNow inserted as local time","user":{"login":"KennyEliasson","id":160862,"avatar_url":"https://avatars.githubusercontent.com/u/160862?v=3","gravatar_id":"","url":"https://api.github.com/users/KennyEliasson","html_url":"https://github.com/KennyEliasson","followers_url":"https://api.github.com/users/KennyEliasson/followers","following_url":"https://api.github.com/users/KennyEliasson/following{/other_user}","gists_url":"https://api.github.com/users/KennyEliasson/gists{/gist_id}","starred_url":"https://api.github.com/users/KennyEliasson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KennyEliasson/subscriptions","organizations_url":"https://api.github.com/users/KennyEliasson/orgs","repos_url":"https://api.github.com/users/KennyEliasson/repos","events_url":"https://api.github.com/users/KennyEliasson/events{/privacy}","received_events_url":"https://api.github.com/users/KennyEliasson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/npgsql/npgsql/labels/bug","name":"bug","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/npgsql/npgsql/milestones/26","html_url":"https://github.com/npgsql/npgsql/milestones/3.0.8","labels_url":"https://api.github.com/repos/npgsql/npgsql/milestones/26/labels","id":1744407,"number":26,"title":"3.0.8","description":"","creator":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":6,"state":"open","created_at":"2016-05-03T09:31:26Z","updated_at":"2016-05-12T12:54:46Z","due_on":null,"closed_at":null},"comments":14,"created_at":"2016-02-05T15:52:07Z","updated_at":"2016-05-12T15:55:13Z","closed_at":null,"body":"Hi,\r\n\r\nI'm using Dapper and DapperExtensions and found some strange issues that I can narrow down to the following code.\r\n```\r\nvar p = new DynamicParameters();\r\np.Add(\"LastSeen\", DateTime.UtcNow);\r\np.Add(\"userID\", user.Id);\r\nconnection.Execute(\"UPDATE Users SET \\\"lastseen\\\" = @lastSeen WHERE Id = @userId\", p);\r\n```\r\n\r\nInstead of saving the UtcTime it will save the local time.\r\n\r\nIf I instead set the parameters myself it will work\r\n\r\n```\r\nconnection.Execute(\"UPDATE Users SET \\\"lastseen\\\" = @lastSeen WHERE Id = @userId\", new { lastSeen = DateTime.UtcNow, userId = 1)};\r\n```\r\n\r\nThe following code will work in MySql-environment which brings me to believe this is a Postgres issue instead of a Dapper issue.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/218801774","html_url":"https://github.com/npgsql/npgsql/issues/972#issuecomment-218801774","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/972","id":218801774,"user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"created_at":"2016-05-12T15:55:13Z","updated_at":"2016-05-12T15:55:13Z","body":"@JCapriotti yeah, a code sample would help out - I need a simple schema and a few lines of C# code that reproduce this."}}