[ https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351046#comment-14351046 ]
Alicia Ying Shu edited comment on PHOENIX-1704 at 3/6/15 10:41 PM: ------------------------------------------------------------------- Thanks. [~jeffreyz] I uploaded another version of the patch containing the test cases you mentioned. was (Author: aliciashu): Thanks. Jeff. I uploaded another version of the patch containing the test cases you mentioned. > Add year() built-in function > ---------------------------- > > Key: PHOENIX-1704 > URL: https://issues.apache.org/jira/browse/PHOENIX-1704 > Project: Phoenix > Issue Type: Bug > Reporter: Alicia Ying Shu > Assignee: Alicia Ying Shu > Attachments: Phoenix-1704-v1.patch, Phoenix-1704.patch > > > SELECT YEAR('2014-12-13 10:13:18', 'yyyy-MM-dd hh:mm:ss') FROM YEARFUNC --> > 2014 > SELECT YEAR('2014-12-13') FROM YEARFUNC --> 2014 > SELECT YEAR('Sat, 3 Feb 2014 03:05:06 GMT', 'EEE, d MMM yyyy HH:mm:ss z', > 'UTC') FROM YEARFUNC --> 2014 -- This message was sent by Atlassian JIRA (v6.3.4#6332)