{"action":"opened","issue":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2925","repository_url":"https://api.github.com/repos/sequelpro/sequelpro","labels_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2925/labels{/name}","comments_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2925/comments","events_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2925/events","html_url":"https://github.com/sequelpro/sequelpro/issues/2925","id":274753719,"number":2925,"title":"date and time chooser","user":{"login":"ftrotter","id":83133,"avatar_url":"https://avatars3.githubusercontent.com/u/83133?v=4","gravatar_id":"","url":"https://api.github.com/users/ftrotter","html_url":"https://github.com/ftrotter","followers_url":"https://api.github.com/users/ftrotter/followers","following_url":"https://api.github.com/users/ftrotter/following{/other_user}","gists_url":"https://api.github.com/users/ftrotter/gists{/gist_id}","starred_url":"https://api.github.com/users/ftrotter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ftrotter/subscriptions","organizations_url":"https://api.github.com/users/ftrotter/orgs","repos_url":"https://api.github.com/users/ftrotter/repos","events_url":"https://api.github.com/users/ftrotter/events{/privacy}","received_events_url":"https://api.github.com/users/ftrotter/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-11-17T05:11:26Z","updated_at":"2017-11-17T05:11:26Z","closed_at":null,"author_association":"NONE","body":"When clicking a field with a type of \"date\" a date chooser (as well as text field to enter a date) should appear. \r\n\r\nWhen clicking a TIMESTAMP or DATETIME field, a date and time chooser should appear. Similar choosers should be available for TIME and YEAR fields. \r\n\r\nThis dramatically accelerates software development. \r\n\r\n<img width=\"1421\" alt=\"date and time chooser\" src=\"https://user-images.githubusercontent.com/83133/32930218-e790bc30-cb22-11e7-99f7-0203e09089bb.png\">\r\n\r\nIt would also be nice to automatically support the calling of sensible functions when editing datetime fields. Things like NOW()  CURRENT_DATE() and CURRENT_TIME(). The following video shows how this happens in phpmyadmin. \r\n\r\nhttps://screencast.com/t/Vvr7smsfs\r\n\r\nI know that this could be asking for a lot, given how clean and simple the sequelpro interface is. But it would really accelerate data entry and data modification tasks. \r\n\r\n-FT"}}
{"actor":{"display_login":"ftrotter"}}