[
https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351852#comment-14351852
]
Alicia Ying Shu edited comment on PHOENIX-1704 at 3/8/15 8:51 AM:
------------------------------------------------------------------
[~jamestaylor] Our customers 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.
was (Author: aliciashu):
[~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)
