{"action":"created","issue":{"url":"https://api.github.com/repos/scrapinghub/dateparser/issues/224","repository_url":"https://api.github.com/repos/scrapinghub/dateparser","labels_url":"https://api.github.com/repos/scrapinghub/dateparser/issues/224/labels{/name}","comments_url":"https://api.github.com/repos/scrapinghub/dateparser/issues/224/comments","events_url":"https://api.github.com/repos/scrapinghub/dateparser/issues/224/events","html_url":"https://github.com/scrapinghub/dateparser/issues/224","id":173930330,"number":224,"title":"Please add support for default SQLite date/time format","user":{"login":"dswhite42","id":13909061,"avatar_url":"https://avatars.githubusercontent.com/u/13909061?v=3","gravatar_id":"","url":"https://api.github.com/users/dswhite42","html_url":"https://github.com/dswhite42","followers_url":"https://api.github.com/users/dswhite42/followers","following_url":"https://api.github.com/users/dswhite42/following{/other_user}","gists_url":"https://api.github.com/users/dswhite42/gists{/gist_id}","starred_url":"https://api.github.com/users/dswhite42/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dswhite42/subscriptions","organizations_url":"https://api.github.com/users/dswhite42/orgs","repos_url":"https://api.github.com/users/dswhite42/repos","events_url":"https://api.github.com/users/dswhite42/events{/privacy}","received_events_url":"https://api.github.com/users/dswhite42/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/scrapinghub/dateparser/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/scrapinghub/dateparser/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-30T05:00:49Z","updated_at":"2016-09-02T17:39:11Z","closed_at":null,"body":"SQLite stores text dates in YYYY-MM-DD HH:MM:SS.SSS format.  It's the decimal fraction that throws dateparser off:\r\n\r\n    >>> type(dateparser.parse('2016-08-30 12:30:45'))\r\n    <class 'datetime.datetime'>\r\n    >>> type(dateparser.parse('2016-08-30 12:30:45.060325'))\r\n    <class 'NoneType'>\r\n\r\nCan this support be added?\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/scrapinghub/dateparser/issues/comments/244440572","html_url":"https://github.com/scrapinghub/dateparser/issues/224#issuecomment-244440572","issue_url":"https://api.github.com/repos/scrapinghub/dateparser/issues/224","id":244440572,"user":{"login":"waqasshabbir","id":1888537,"avatar_url":"https://avatars.githubusercontent.com/u/1888537?v=3","gravatar_id":"","url":"https://api.github.com/users/waqasshabbir","html_url":"https://github.com/waqasshabbir","followers_url":"https://api.github.com/users/waqasshabbir/followers","following_url":"https://api.github.com/users/waqasshabbir/following{/other_user}","gists_url":"https://api.github.com/users/waqasshabbir/gists{/gist_id}","starred_url":"https://api.github.com/users/waqasshabbir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/waqasshabbir/subscriptions","organizations_url":"https://api.github.com/users/waqasshabbir/orgs","repos_url":"https://api.github.com/users/waqasshabbir/repos","events_url":"https://api.github.com/users/waqasshabbir/events{/privacy}","received_events_url":"https://api.github.com/users/waqasshabbir/received_events","type":"User","site_admin":false},"created_at":"2016-09-02T17:39:11Z","updated_at":"2016-09-02T17:39:11Z","body":"This was already fixed a week after `0.4.0` was released. See 9f5caee. However, there's still a limit on number of decimal places (micro = 6).\r\n\r\n```\r\nIn [2]: parse('2016-08-30 12:30:45.060325')\r\nOut[2]: datetime.datetime(2016, 8, 30, 12, 30, 45, 60325)\r\n\r\nIn [3]: parse('2016-08-30T12:30:45.060325')\r\nOut[3]: datetime.datetime(2016, 8, 30, 12, 30, 45, 60325)\r\n```\r\n\r\nI tried to eliminate the *limit* but it reduced accuracy. "}}
{"actor":{"display_login":"waqasshabbir"}}