{"action":"created","issue":{"url":"https://api.github.com/repos/dg/dibi/issues/180","repository_url":"https://api.github.com/repos/dg/dibi","labels_url":"https://api.github.com/repos/dg/dibi/issues/180/labels{/name}","comments_url":"https://api.github.com/repos/dg/dibi/issues/180/comments","events_url":"https://api.github.com/repos/dg/dibi/issues/180/events","html_url":"https://github.com/dg/dibi/issues/180","id":89067945,"number":180,"title":"MsSQL returned value of datetime column can not be normalized, no chance to get DateTime","user":{"login":"matak","id":164995,"avatar_url":"https://avatars.githubusercontent.com/u/164995?v=3","gravatar_id":"","url":"https://api.github.com/users/matak","html_url":"https://github.com/matak","followers_url":"https://api.github.com/users/matak/followers","following_url":"https://api.github.com/users/matak/following{/other_user}","gists_url":"https://api.github.com/users/matak/gists{/gist_id}","starred_url":"https://api.github.com/users/matak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matak/subscriptions","organizations_url":"https://api.github.com/users/matak/orgs","repos_url":"https://api.github.com/users/matak/repos","events_url":"https://api.github.com/users/matak/events{/privacy}","received_events_url":"https://api.github.com/users/matak/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2015-06-17T16:45:03Z","updated_at":"2016-09-02T13:06:58Z","closed_at":null,"body":"if you select datetime column mssql returns\r\n\r\nsomething like this\r\n\r\nJun 17 2015 12:00:00:000AM\r\n\r\nbut normalize function will not create DateTime object bcs\r\n\r\nhttps://github.com/dg/dibi/blob/master/dibi/libs/DibiResult.php#L508\r\n\r\nthis is not true\r\n\r\n(int) $value !== 0\r\n\r\nif you want to get from mssql date format like this 2015-06-17 00:00:00\r\n\r\nyou need to use this\r\n\r\nCONVERT(VARCHAR(19), d.Datum, 120) as Datum,\r\n\r\nin your query, but this will be detected like string not datetime so again DateTime object will not be created\r\n"},"comment":{"url":"https://api.github.com/repos/dg/dibi/issues/comments/244369646","html_url":"https://github.com/dg/dibi/issues/180#issuecomment-244369646","issue_url":"https://api.github.com/repos/dg/dibi/issues/180","id":244369646,"user":{"login":"dg","id":194960,"avatar_url":"https://avatars.githubusercontent.com/u/194960?v=3","gravatar_id":"","url":"https://api.github.com/users/dg","html_url":"https://github.com/dg","followers_url":"https://api.github.com/users/dg/followers","following_url":"https://api.github.com/users/dg/following{/other_user}","gists_url":"https://api.github.com/users/dg/gists{/gist_id}","starred_url":"https://api.github.com/users/dg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dg/subscriptions","organizations_url":"https://api.github.com/users/dg/orgs","repos_url":"https://api.github.com/users/dg/repos","events_url":"https://api.github.com/users/dg/events{/privacy}","received_events_url":"https://api.github.com/users/dg/received_events","type":"User","site_admin":false},"created_at":"2016-09-02T13:06:58Z","updated_at":"2016-09-02T13:06:58Z","body":"Probably condition can be improved to accept this format."}}
{"actor":{"display_login":"dg"}}