{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/854","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/854/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/854/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/854/events","html_url":"https://github.com/npgsql/npgsql/issues/854","id":115183799,"number":854,"title":"Unable to run a query with a TimeSpan parameter of length > 24h in Npgsql 3.0","user":{"login":"haeal","id":2153860,"avatar_url":"https://avatars.githubusercontent.com/u/2153860?v=3","gravatar_id":"","url":"https://api.github.com/users/haeal","html_url":"https://github.com/haeal","followers_url":"https://api.github.com/users/haeal/followers","following_url":"https://api.github.com/users/haeal/following{/other_user}","gists_url":"https://api.github.com/users/haeal/gists{/gist_id}","starred_url":"https://api.github.com/users/haeal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haeal/subscriptions","organizations_url":"https://api.github.com/users/haeal/orgs","repos_url":"https://api.github.com/users/haeal/repos","events_url":"https://api.github.com/users/haeal/events{/privacy}","received_events_url":"https://api.github.com/users/haeal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-05T00:44:46Z","updated_at":"2015-11-05T01:00:46Z","closed_at":null,"body":"After upgrading our project from 2.x to 3.0, I have found that I am unable to store a TimeSpan with a duration longer than 24 hours.  A length of time <= 24h exactly works fine.  I can retrieve an interval > 24 hours fine.  Only passing it in as a parameter breaks.\r\n\r\nThe error I get is \"22008: time out of range\".  I am running the 3.0.3 build.\r\n\r\nA simple code segment here causes the issue.\r\n\r\n```\r\nusing (NpgsqlConnection conn = new NpgsqlConnection(DbConnString))\r\n{\r\n\tconn.Open();\r\n\tNpgsqlCommand comm = conn.CreateCommand();\r\n\tcomm.CommandText = \"SELECT :given as theinterval\";\r\n\tcomm.Parameters.Clear();\r\n\tcomm.Parameters.AddWithValue(\"given\", new TimeSpan(25, 0, 0));\r\n\tusing (NpgsqlDataReader reader = comm.ExecuteReader())\r\n\t{\r\n\t\treader.Read();\r\n\t\tConsole.WriteLine(reader[\"theinterval\"]);\r\n\t\tConsole.WriteLine(reader[\"theinterval\"].GetType());\r\n\t}\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/153919697","html_url":"https://github.com/npgsql/npgsql/issues/854#issuecomment-153919697","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/854","id":153919697,"user":{"login":"haeal","id":2153860,"avatar_url":"https://avatars.githubusercontent.com/u/2153860?v=3","gravatar_id":"","url":"https://api.github.com/users/haeal","html_url":"https://github.com/haeal","followers_url":"https://api.github.com/users/haeal/followers","following_url":"https://api.github.com/users/haeal/following{/other_user}","gists_url":"https://api.github.com/users/haeal/gists{/gist_id}","starred_url":"https://api.github.com/users/haeal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haeal/subscriptions","organizations_url":"https://api.github.com/users/haeal/orgs","repos_url":"https://api.github.com/users/haeal/repos","events_url":"https://api.github.com/users/haeal/events{/privacy}","received_events_url":"https://api.github.com/users/haeal/received_events","type":"User","site_admin":false},"created_at":"2015-11-05T01:00:46Z","updated_at":"2015-11-05T01:00:46Z","body":"That would be great!  :+1: I've downloaded the src and made changes myself to that effect and have been able to get all my test code going.  Unfortunately I haven't been able to get the tests running yet.  I'm very new to DNX and only just figured out that I can't do this through Visual Studio 2015, instead build using `dnx build`.\r\n\r\nAre there any instructions anywhere for getting the tests going?"}}