{"action":"created","issue":{"url":"https://api.github.com/repos/django/django/issues/4281","labels_url":"https://api.github.com/repos/django/django/issues/4281/labels{/name}","comments_url":"https://api.github.com/repos/django/django/issues/4281/comments","events_url":"https://api.github.com/repos/django/django/issues/4281/events","html_url":"https://github.com/django/django/pull/4281","id":60271704,"number":4281,"title":"Fixed #9596 -- Added date transform for DateTimeField","user":{"login":"jdufresne","id":347634,"avatar_url":"https://avatars.githubusercontent.com/u/347634?v=3","gravatar_id":"","url":"https://api.github.com/users/jdufresne","html_url":"https://github.com/jdufresne","followers_url":"https://api.github.com/users/jdufresne/followers","following_url":"https://api.github.com/users/jdufresne/following{/other_user}","gists_url":"https://api.github.com/users/jdufresne/gists{/gist_id}","starred_url":"https://api.github.com/users/jdufresne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdufresne/subscriptions","organizations_url":"https://api.github.com/users/jdufresne/orgs","repos_url":"https://api.github.com/users/jdufresne/repos","events_url":"https://api.github.com/users/jdufresne/events{/privacy}","received_events_url":"https://api.github.com/users/jdufresne/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":17,"created_at":"2015-03-08T19:24:21Z","updated_at":"2015-03-27T19:23:15Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/django/django/pulls/4281","html_url":"https://github.com/django/django/pull/4281","diff_url":"https://github.com/django/django/pull/4281.diff","patch_url":"https://github.com/django/django/pull/4281.patch"},"body":"This change allows querying `DateTimeField`s by the date portion. Such as:\r\n\r\n```\r\nArticles.objects.filter(published_at__date=datetime.date.today())\r\n```\r\n\r\nSome concerns and questions:\r\n\r\n1. I do not use Oracle DB. The Oracle implementation was created by reading Oracle documentation and other web searches. It has not been tested, nor is it known to be correct. Feedback from Oracle developers would be appreciated. All other built-in backends were tested.\r\n2. Should I add a `TimeTransform` while I'm at it? To allow users to query on the time portion of a `DateTimeField`. If others think it is a good idea, I wouldn't mind adding it.\r\n3. In DB backend `operations.py`, when converting a column to a timezone, should the timezone be returned as a format parameter to the SQL string (as in MySQL and Postgres) or should the timezone be embedded in the returned SQL string (as in Oracle)?\r\n\r\nThanks. All feedback appreciated."},"comment":{"url":"https://api.github.com/repos/django/django/issues/comments/87064353","html_url":"https://github.com/django/django/pull/4281#issuecomment-87064353","issue_url":"https://api.github.com/repos/django/django/issues/4281","id":87064353,"user":{"login":"jdufresne","id":347634,"avatar_url":"https://avatars.githubusercontent.com/u/347634?v=3","gravatar_id":"","url":"https://api.github.com/users/jdufresne","html_url":"https://github.com/jdufresne","followers_url":"https://api.github.com/users/jdufresne/followers","following_url":"https://api.github.com/users/jdufresne/following{/other_user}","gists_url":"https://api.github.com/users/jdufresne/gists{/gist_id}","starred_url":"https://api.github.com/users/jdufresne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdufresne/subscriptions","organizations_url":"https://api.github.com/users/jdufresne/orgs","repos_url":"https://api.github.com/users/jdufresne/repos","events_url":"https://api.github.com/users/jdufresne/events{/privacy}","received_events_url":"https://api.github.com/users/jdufresne/received_events","type":"User","site_admin":false},"created_at":"2015-03-27T19:23:15Z","updated_at":"2015-03-27T19:23:15Z","body":"Thanks @timgraham I will take a look at installing Oracle to debug the issue."}}