[ https://issues.apache.org/jira/browse/PHOENIX-1756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14372299#comment-14372299 ]
Alicia Ying Shu edited comment on PHOENIX-1756 at 3/21/15 12:39 AM: -------------------------------------------------------------------- We picked the functions based on what time functions customers would use mostly. In Phoenix-1765, will implement WEEK(date), Minute(), Hour(), DAYOFMONTH(). was (Author: aliciashu): We picked the functions based on what time functions customers would use mostly. In Phoenix-1765, will implement WEEK(date), Minute(), Hour(), Day() and MillisOfSecond() as well. > Add Month() and Second() buildin functions > ------------------------------------------ > > Key: PHOENIX-1756 > URL: https://issues.apache.org/jira/browse/PHOENIX-1756 > Project: Phoenix > Issue Type: Improvement > Reporter: Alicia Ying Shu > Assignee: Alicia Ying Shu > Attachments: Phoenix-1756.patch > > > From Oracle doc: Month(date) and Second(date). Very similar to Year(date) > buildin. > MONTH(date) An integer from 1 to 12 representing the month > component of date > SECOND(time) An integer from 0 to 59 representing the second > component of time -- This message was sent by Atlassian JIRA (v6.3.4#6332)