[
https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351852#comment-14351852
]
Alicia Ying Shu commented on PHOENIX-1704:
------------------------------------------
[~jamestaylor] Our customer want it. Month() and Second() are also in the top
of the list. The use case is like Year(now()). Year() returns an integer not
time so needs its own treat as a scalar function. Thus Year(epoch) is not
really needed. We want this buildin function to be in soon. Thanks.
> 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)
