{"action":"created","issue":{"url":"https://api.github.com/repos/tminglei/slick-pg/issues/220","labels_url":"https://api.github.com/repos/tminglei/slick-pg/issues/220/labels{/name}","comments_url":"https://api.github.com/repos/tminglei/slick-pg/issues/220/comments","events_url":"https://api.github.com/repos/tminglei/slick-pg/issues/220/events","html_url":"https://github.com/tminglei/slick-pg/issues/220","id":111861077,"number":220,"title":"Invalid format is too short","user":{"login":"simao","id":203575,"avatar_url":"https://avatars.githubusercontent.com/u/203575?v=3","gravatar_id":"","url":"https://api.github.com/users/simao","html_url":"https://github.com/simao","followers_url":"https://api.github.com/users/simao/followers","following_url":"https://api.github.com/users/simao/following{/other_user}","gists_url":"https://api.github.com/users/simao/gists{/gist_id}","starred_url":"https://api.github.com/users/simao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simao/subscriptions","organizations_url":"https://api.github.com/users/simao/orgs","repos_url":"https://api.github.com/users/simao/repos","events_url":"https://api.github.com/users/simao/events{/privacy}","received_events_url":"https://api.github.com/users/simao/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":29,"created_at":"2015-10-16T16:03:32Z","updated_at":"2015-11-20T11:28:29Z","closed_at":null,"body":"Hi,\r\n\r\nWhen using joda time with slick-pg I get the following error when reading a record from the database:\r\n\r\n    Invalid format: \"2015-10-16 15:56:04.041\" is too short.\r\n\r\nIs this a known problem? Seems the database is returning a string without the timezone.\r\n\r\nIn the database the record is stored as \"2015-10-16 15:56:04.041+02\"\r\n\r\nThank you"},"comment":{"url":"https://api.github.com/repos/tminglei/slick-pg/issues/comments/158367969","html_url":"https://github.com/tminglei/slick-pg/issues/220#issuecomment-158367969","issue_url":"https://api.github.com/repos/tminglei/slick-pg/issues/220","id":158367969,"user":{"login":"jan0sch","id":373810,"avatar_url":"https://avatars.githubusercontent.com/u/373810?v=3","gravatar_id":"","url":"https://api.github.com/users/jan0sch","html_url":"https://github.com/jan0sch","followers_url":"https://api.github.com/users/jan0sch/followers","following_url":"https://api.github.com/users/jan0sch/following{/other_user}","gists_url":"https://api.github.com/users/jan0sch/gists{/gist_id}","starred_url":"https://api.github.com/users/jan0sch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jan0sch/subscriptions","organizations_url":"https://api.github.com/users/jan0sch/orgs","repos_url":"https://api.github.com/users/jan0sch/repos","events_url":"https://api.github.com/users/jan0sch/events{/privacy}","received_events_url":"https://api.github.com/users/jan0sch/received_events","type":"User","site_admin":false},"created_at":"2015-11-20T11:28:29Z","updated_at":"2015-11-20T11:28:29Z","body":"This is just a quickshot but would something like this maybe provide a workaround until this is officially fixed?\r\n\r\n````\r\ndiff --git a/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java b/org/postgresql/jdbc2/AbstractJdbc2ResultS\r\nindex 64d949f..efbc370 100644\r\n--- a/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java\r\n+++ b/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java\r\n@@ -2986,7 +2986,14 @@ public abstract class AbstractJdbc2ResultSet implements BaseResultSet, org.postg\r\n      * @return True if the column is in binary format.\r\n      */\r\n     protected boolean isBinary(int column) {\r\n-        return fields[column - 1].getFormat() == Field.BINARY_FORMAT;\r\n+        Field f = fields[column - 1];\r\n+        if (f.getPGType().equalsIgnoreCase(\"timestamptz\") || f.getPGType().equalsIgnoreCase(\"timetz\")) {\r\n+            // Prevent binary treating of fields with timezone.\r\n+            return false;\r\n+        }\r\n+        else {\r\n+            return fields[column - 1].getFormat() == Field.BINARY_FORMAT;\r\n+        }\r\n     }\r\n \r\n     //----------------- Formatting Methods -------------------\r\n````\r\n"}}