{"action":"created","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/1843","repository_url":"https://api.github.com/repos/sequelize/sequelize","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/1843/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/1843/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/1843/events","html_url":"https://github.com/sequelize/sequelize/issues/1843","id":34744397,"number":1843,"title":"DATE type gets truncated to seconds","user":{"login":"jylin","id":62266,"avatar_url":"https://avatars.githubusercontent.com/u/62266?v=3","gravatar_id":"","url":"https://api.github.com/users/jylin","html_url":"https://github.com/jylin","followers_url":"https://api.github.com/users/jylin/followers","following_url":"https://api.github.com/users/jylin/following{/other_user}","gists_url":"https://api.github.com/users/jylin/gists{/gist_id}","starred_url":"https://api.github.com/users/jylin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jylin/subscriptions","organizations_url":"https://api.github.com/users/jylin/orgs","repos_url":"https://api.github.com/users/jylin/repos","events_url":"https://api.github.com/users/jylin/events{/privacy}","received_events_url":"https://api.github.com/users/jylin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sequelize/sequelize/labels/bug","name":"bug","color":"d7e102"},{"url":"https://api.github.com/repos/sequelize/sequelize/labels/question","name":"question","color":"02d7e1"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2014-06-02T03:35:01Z","updated_at":"2016-10-12T13:35:29Z","closed_at":"2014-06-02T19:28:43Z","body":"I'm using a Sqlite (and memory backend for tests), and it seems like DATE types get truncated to seconds even though you saved a `new Date()` which should be milliseconds. Hence tests that compare dates fail because the last 3 digits are always 0 when read from Sequelize."},"comment":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/comments/253214899","html_url":"https://github.com/sequelize/sequelize/issues/1843#issuecomment-253214899","issue_url":"https://api.github.com/repos/sequelize/sequelize/issues/1843","id":253214899,"user":{"login":"aiwb","id":510080,"avatar_url":"https://avatars.githubusercontent.com/u/510080?v=3","gravatar_id":"","url":"https://api.github.com/users/aiwb","html_url":"https://github.com/aiwb","followers_url":"https://api.github.com/users/aiwb/followers","following_url":"https://api.github.com/users/aiwb/following{/other_user}","gists_url":"https://api.github.com/users/aiwb/gists{/gist_id}","starred_url":"https://api.github.com/users/aiwb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aiwb/subscriptions","organizations_url":"https://api.github.com/users/aiwb/orgs","repos_url":"https://api.github.com/users/aiwb/repos","events_url":"https://api.github.com/users/aiwb/events{/privacy}","received_events_url":"https://api.github.com/users/aiwb/received_events","type":"User","site_admin":false},"created_at":"2016-10-12T13:35:29Z","updated_at":"2016-10-12T13:35:29Z","body":"how can i turn the default createdAt and updatedAt field type from DATE to INT or BIGINT in mysql"}}
{"actor":{"display_login":"aiwb"}}