{"action":"opened","issue":{"url":"https://api.github.com/repos/fukamachi/cl-dbi/issues/26","labels_url":"https://api.github.com/repos/fukamachi/cl-dbi/issues/26/labels{/name}","comments_url":"https://api.github.com/repos/fukamachi/cl-dbi/issues/26/comments","events_url":"https://api.github.com/repos/fukamachi/cl-dbi/issues/26/events","html_url":"https://github.com/fukamachi/cl-dbi/issues/26","id":126992293,"number":26,"title":"Postgres and timestamp values","user":{"login":"eudoxia0","id":1612511,"avatar_url":"https://avatars.githubusercontent.com/u/1612511?v=3","gravatar_id":"","url":"https://api.github.com/users/eudoxia0","html_url":"https://github.com/eudoxia0","followers_url":"https://api.github.com/users/eudoxia0/followers","following_url":"https://api.github.com/users/eudoxia0/following{/other_user}","gists_url":"https://api.github.com/users/eudoxia0/gists{/gist_id}","starred_url":"https://api.github.com/users/eudoxia0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eudoxia0/subscriptions","organizations_url":"https://api.github.com/users/eudoxia0/orgs","repos_url":"https://api.github.com/users/eudoxia0/repos","events_url":"https://api.github.com/users/eudoxia0/events{/privacy}","received_events_url":"https://api.github.com/users/eudoxia0/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-16T01:39:26Z","updated_at":"2016-01-16T01:39:26Z","closed_at":null,"body":"Inserting timestamp data into Postgres is not a problem since it reads ISO 8601, but reading it is, since `local-time` can't parse strings like `\"2016-01-16 01:28:08.926922+00\"`.\r\n\r\nNow, cl-postgres has [a function](https://marijnhaverbeke.nl/postmodern/cl-postgres.html#set-sql-datetime-readers) to define functions to read the timestamps from simpler values.\r\n\r\nI think an option in the driver object to set the timestamp reader function would be useful. Changing it by default would break backwards compatibility, but setting it optionally would work."}}