{"action":"created","issue":{"url":"https://api.github.com/repos/prestodb/presto/issues/9524","repository_url":"https://api.github.com/repos/prestodb/presto","labels_url":"https://api.github.com/repos/prestodb/presto/issues/9524/labels{/name}","comments_url":"https://api.github.com/repos/prestodb/presto/issues/9524/comments","events_url":"https://api.github.com/repos/prestodb/presto/issues/9524/events","html_url":"https://github.com/prestodb/presto/issues/9524","id":280823799,"node_id":"MDU6SXNzdWUyODA4MjM3OTk=","number":9524,"title":"Support extracting milliseconds from a timestamp","user":{"login":"findepi","id":144328,"node_id":"MDQ6VXNlcjE0NDMyOA==","avatar_url":"https://avatars0.githubusercontent.com/u/144328?v=4","gravatar_id":"","url":"https://api.github.com/users/findepi","html_url":"https://github.com/findepi","followers_url":"https://api.github.com/users/findepi/followers","following_url":"https://api.github.com/users/findepi/following{/other_user}","gists_url":"https://api.github.com/users/findepi/gists{/gist_id}","starred_url":"https://api.github.com/users/findepi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/findepi/subscriptions","organizations_url":"https://api.github.com/users/findepi/orgs","repos_url":"https://api.github.com/users/findepi/repos","events_url":"https://api.github.com/users/findepi/events{/privacy}","received_events_url":"https://api.github.com/users/findepi/received_events","type":"User","site_admin":false},"labels":[{"id":136288195,"node_id":"MDU6TGFiZWwxMzYyODgxOTU=","url":"https://api.github.com/repos/prestodb/presto/labels/beginner-task","name":"beginner-task","color":"009800","default":false},{"id":11191947,"node_id":"MDU6TGFiZWwxMTE5MTk0Nw==","url":"https://api.github.com/repos/prestodb/presto/labels/enhancement","name":"enhancement","color":"d4c5f9","default":true},{"id":260296146,"node_id":"MDU6TGFiZWwyNjAyOTYxNDY=","url":"https://api.github.com/repos/prestodb/presto/labels/syntax-needs-review","name":"syntax-needs-review","color":"f7c6c7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-12-10T16:47:36Z","updated_at":"2018-11-26T21:51:05Z","closed_at":null,"author_association":"MEMBER","body":"```\r\npresto> select extract(second from (timestamp '2017-10-24 23:00:23.206'));\r\n _col0\r\n-------\r\n    23\r\n```\r\n\r\nbut\r\n```\r\npresto> select extract(millisecond from (timestamp '2017-10-24 23:00:23.206'));\r\nQuery 20171208_215149_00048_uhmtc failed: line 1:8: Invalid EXTRACT field: millisecond\r\n```\r\n\r\nIMO this should be supported."},"comment":{"url":"https://api.github.com/repos/prestodb/presto/issues/comments/441812458","html_url":"https://github.com/prestodb/presto/issues/9524#issuecomment-441812458","issue_url":"https://api.github.com/repos/prestodb/presto/issues/9524","id":441812458,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTgxMjQ1OA==","user":{"login":"martint","id":14387,"node_id":"MDQ6VXNlcjE0Mzg3","avatar_url":"https://avatars3.githubusercontent.com/u/14387?v=4","gravatar_id":"","url":"https://api.github.com/users/martint","html_url":"https://github.com/martint","followers_url":"https://api.github.com/users/martint/followers","following_url":"https://api.github.com/users/martint/following{/other_user}","gists_url":"https://api.github.com/users/martint/gists{/gist_id}","starred_url":"https://api.github.com/users/martint/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martint/subscriptions","organizations_url":"https://api.github.com/users/martint/orgs","repos_url":"https://api.github.com/users/martint/repos","events_url":"https://api.github.com/users/martint/events{/privacy}","received_events_url":"https://api.github.com/users/martint/received_events","type":"User","site_admin":false},"created_at":"2018-11-26T21:51:05Z","updated_at":"2018-11-26T21:51:05Z","author_association":"CONTRIBUTOR","body":"> @martint i said decimal(5,3) because our timestamp corresponds to SQL standard's timestamp(3).\r\n\r\nI understand where that came from, but I don't think there's anywhere currently in Presto where a precision of 3 is implied. It might as well be `timestamp(6)` but without enough accuracy to have anything other than 0s after the 3rd decimal digit."}}
{"actor":{"display_login":"martint"}}