phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alicia Ying Shu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-1704) Add year() built-in function
Date Sun, 08 Mar 2015 08:51:38 GMT

    [ 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)

Mime
View raw message