{"action":"created","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/1411","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/1411/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/1411/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/1411/events","html_url":"https://github.com/tgriesser/knex/pull/1411","id":154894354,"number":1411,"title":"Allow creating datetime in mysql with fractional second part","user":{"login":"JWells","id":385872,"avatar_url":"https://avatars.githubusercontent.com/u/385872?v=3","gravatar_id":"","url":"https://api.github.com/users/JWells","html_url":"https://github.com/JWells","followers_url":"https://api.github.com/users/JWells/followers","following_url":"https://api.github.com/users/JWells/following{/other_user}","gists_url":"https://api.github.com/users/JWells/gists{/gist_id}","starred_url":"https://api.github.com/users/JWells/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JWells/subscriptions","organizations_url":"https://api.github.com/users/JWells/orgs","repos_url":"https://api.github.com/users/JWells/repos","events_url":"https://api.github.com/users/JWells/events{/privacy}","received_events_url":"https://api.github.com/users/JWells/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-15T07:06:01Z","updated_at":"2016-06-19T03:38:52Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/tgriesser/knex/pulls/1411","html_url":"https://github.com/tgriesser/knex/pull/1411","diff_url":"https://github.com/tgriesser/knex/pull/1411.diff","patch_url":"https://github.com/tgriesser/knex/pull/1411.patch"},"body":"Hi, just a small change to allow setting the fractional second part to datetime columns in mysql.\r\n\r\ne.g.\r\ntable.datetime('created_at', 6)\r\n\r\nwill allow\r\n```\r\nmysql> select created_at from users;\r\n+----------------------------+\r\n| created_at                 |\r\n+----------------------------+\r\n| 2016-05-15 16:56:24.831000 |\r\n+----------------------------+\r\n```"},"comment":{"url":"https://api.github.com/repos/tgriesser/knex/issues/comments/226977572","html_url":"https://github.com/tgriesser/knex/pull/1411#issuecomment-226977572","issue_url":"https://api.github.com/repos/tgriesser/knex/issues/1411","id":226977572,"user":{"login":"JWells","id":385872,"avatar_url":"https://avatars.githubusercontent.com/u/385872?v=3","gravatar_id":"","url":"https://api.github.com/users/JWells","html_url":"https://github.com/JWells","followers_url":"https://api.github.com/users/JWells/followers","following_url":"https://api.github.com/users/JWells/following{/other_user}","gists_url":"https://api.github.com/users/JWells/gists{/gist_id}","starred_url":"https://api.github.com/users/JWells/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JWells/subscriptions","organizations_url":"https://api.github.com/users/JWells/orgs","repos_url":"https://api.github.com/users/JWells/repos","events_url":"https://api.github.com/users/JWells/events{/privacy}","received_events_url":"https://api.github.com/users/JWells/received_events","type":"User","site_admin":false},"created_at":"2016-06-19T03:38:52Z","updated_at":"2016-06-19T03:38:52Z","body":"No problems. I've updated the docs for this one to get at least the MySQL part done. I agree it should be updated to be consistent across the board. I think that should be separate commits though so left it out of this one. Will try and take a look at updating the postgres ones soon."}}
{"actor":{"display_login":"JWells"}}