[ https://issues.apache.org/jira/browse/HIVE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaobing Zhou updated HIVE-9480: -------------------------------- Attachment: HIVE-9480.5.patch Patch V5 addressed review comments. > Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY > ---------------------------------------------------------------- > > Key: HIVE-9480 > URL: https://issues.apache.org/jira/browse/HIVE-9480 > Project: Hive > Issue Type: Bug > Components: UDF > Affects Versions: 0.14.0 > Reporter: Xiaobing Zhou > Assignee: Xiaobing Zhou > Attachments: HIVE-9480.1.patch, HIVE-9480.3.patch, HIVE-9480.4.patch, > HIVE-9480.5.patch > > > Hive already supports LAST_DAY UDF, in some cases, FIRST_DAY is necessary to > do date/timestamp related computation. This JIRA is to track such an > implementation. Choose to impl TRUNC, a more standard way to get the first > day of a a month, e.g., SELECT TRUNC('2009-01-12', 'MM') FROM src LIMIT 1; > will return 2009-01-01 > BTW, this TRUNC is not as feature complete as aligned with Oracle one. 'MM' > is the only format supported, however, it's a base to add on other formats. -- This message was sent by Atlassian JIRA (v6.3.4#6332)