{"action":"created","issue":{"url":"https://api.github.com/repos/agershun/alasql/issues/1021","repository_url":"https://api.github.com/repos/agershun/alasql","labels_url":"https://api.github.com/repos/agershun/alasql/issues/1021/labels{/name}","comments_url":"https://api.github.com/repos/agershun/alasql/issues/1021/comments","events_url":"https://api.github.com/repos/agershun/alasql/issues/1021/events","html_url":"https://github.com/agershun/alasql/issues/1021","id":334533070,"node_id":"MDU6SXNzdWUzMzQ1MzMwNzA=","number":1021,"title":"Working with dates on Firefox and IE","user":{"login":"hitbraga","id":10741018,"node_id":"MDQ6VXNlcjEwNzQxMDE4","avatar_url":"https://avatars0.githubusercontent.com/u/10741018?v=4","gravatar_id":"","url":"https://api.github.com/users/hitbraga","html_url":"https://github.com/hitbraga","followers_url":"https://api.github.com/users/hitbraga/followers","following_url":"https://api.github.com/users/hitbraga/following{/other_user}","gists_url":"https://api.github.com/users/hitbraga/gists{/gist_id}","starred_url":"https://api.github.com/users/hitbraga/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hitbraga/subscriptions","organizations_url":"https://api.github.com/users/hitbraga/orgs","repos_url":"https://api.github.com/users/hitbraga/repos","events_url":"https://api.github.com/users/hitbraga/events{/privacy}","received_events_url":"https://api.github.com/users/hitbraga/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-21T14:57:32Z","updated_at":"2018-06-21T21:37:08Z","closed_at":null,"author_association":"NONE","body":"Hello all,\r\nI have a Json object with datetime stamps with this format 2018-06-21 15:00:00.\r\nWhen using `console.log(JSON.stringify(alasql('SELECT ROUND(AVG(DATEDIFF(second,\"2018-06-21 15:00:00\",\"2018-06-21 15:00:10\"))/60,1) as MWT FROM ? WHERE id=\"11149\"', [jsontester[0][\"data\"].object_name])));` \r\nFirefox and Chromium it returns the correct value, but on IE does not.\r\nI already test datetime with format like 2018/06/21 15:00:00 and works on both browsers.\r\nCan some one help me. Is there any convert / formating implemented on alasql ?\r\n\r\nUsing:\r\nAlaSQL v0.4.5\r\nIE:11.0.10240\r\nFirefox:52.8.1\r\nChromium(raspberry pi3): 60.0.3112.89 \r\n\r\nThanks and by the way great job.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/agershun/alasql/issues/comments/399251555","html_url":"https://github.com/agershun/alasql/issues/1021#issuecomment-399251555","issue_url":"https://api.github.com/repos/agershun/alasql/issues/1021","id":399251555,"node_id":"MDEyOklzc3VlQ29tbWVudDM5OTI1MTU1NQ==","user":{"login":"mathiasrw","id":1063454,"node_id":"MDQ6VXNlcjEwNjM0NTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/1063454?v=4","gravatar_id":"","url":"https://api.github.com/users/mathiasrw","html_url":"https://github.com/mathiasrw","followers_url":"https://api.github.com/users/mathiasrw/followers","following_url":"https://api.github.com/users/mathiasrw/following{/other_user}","gists_url":"https://api.github.com/users/mathiasrw/gists{/gist_id}","starred_url":"https://api.github.com/users/mathiasrw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mathiasrw/subscriptions","organizations_url":"https://api.github.com/users/mathiasrw/orgs","repos_url":"https://api.github.com/users/mathiasrw/repos","events_url":"https://api.github.com/users/mathiasrw/events{/privacy}","received_events_url":"https://api.github.com/users/mathiasrw/received_events","type":"User","site_admin":false},"created_at":"2018-06-21T21:37:08Z","updated_at":"2018-06-21T21:37:08Z","author_association":"COLLABORATOR","body":"Thank you for reaching out. \r\n\r\nWhat is the correct value of \r\n\r\n```\r\nconsole.log(JSON.stringify(alasql('SELECT ROUND(AVG(DATEDIFF(second,\"2018-06-21 15:00:00\",\"2018-06-21 15:00:10\"))/60,1)\r\n```\r\n\r\n?"}}
{"actor":{"display_login":"mathiasrw"}}