{"action":"created","issue":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/3656","repository_url":"https://api.github.com/repos/Starcounter/Starcounter","labels_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/3656/labels{/name}","comments_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/3656/comments","events_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/3656/events","html_url":"https://github.com/Starcounter/Starcounter/issues/3656","id":156915502,"number":3656,"title":"Question : How can I query DateTime in SC Admin Panel","user":{"login":"atifwaqar","id":4388707,"avatar_url":"https://avatars.githubusercontent.com/u/4388707?v=3","gravatar_id":"","url":"https://api.github.com/users/atifwaqar","html_url":"https://github.com/atifwaqar","followers_url":"https://api.github.com/users/atifwaqar/followers","following_url":"https://api.github.com/users/atifwaqar/following{/other_user}","gists_url":"https://api.github.com/users/atifwaqar/gists{/gist_id}","starred_url":"https://api.github.com/users/atifwaqar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atifwaqar/subscriptions","organizations_url":"https://api.github.com/users/atifwaqar/orgs","repos_url":"https://api.github.com/users/atifwaqar/repos","events_url":"https://api.github.com/users/atifwaqar/events{/privacy}","received_events_url":"https://api.github.com/users/atifwaqar/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/Knowledge%20base","name":"Knowledge base","color":"0e8a16"},{"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/question","name":"question","color":"02d7e1"},{"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/SQL","name":"SQL","color":"000000"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":19,"created_at":"2016-05-26T06:45:40Z","updated_at":"2016-05-27T13:06:51Z","closed_at":null,"body":"Is it possible to execute a Query with DateTime in `WHERE` clause ?\r\nIf not, do you plan to have this in future?"},"comment":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/comments/222141314","html_url":"https://github.com/Starcounter/Starcounter/issues/3656#issuecomment-222141314","issue_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/3656","id":222141314,"user":{"login":"miyconst","id":6435556,"avatar_url":"https://avatars.githubusercontent.com/u/6435556?v=3","gravatar_id":"","url":"https://api.github.com/users/miyconst","html_url":"https://github.com/miyconst","followers_url":"https://api.github.com/users/miyconst/followers","following_url":"https://api.github.com/users/miyconst/following{/other_user}","gists_url":"https://api.github.com/users/miyconst/gists{/gist_id}","starred_url":"https://api.github.com/users/miyconst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/miyconst/subscriptions","organizations_url":"https://api.github.com/users/miyconst/orgs","repos_url":"https://api.github.com/users/miyconst/repos","events_url":"https://api.github.com/users/miyconst/events{/privacy}","received_events_url":"https://api.github.com/users/miyconst/received_events","type":"User","site_admin":false},"created_at":"2016-05-27T13:06:51Z","updated_at":"2016-05-27T13:06:51Z","body":">And on a related note, shouldn't a query that omit the time return a hit\r\n\r\nNo, it should not, unless we provide some sugaring on top. A `DateTime` value is a number value,\r\n`130000 != 130010`, in .NET `DateTime` objects with different time return `false` after comparison.\r\n\r\nIf someone wants to get all entries per day, it should be done with `>=` and `<` operators."}}
{"actor":{"display_login":"miyconst"}}