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 Sat, 07 Mar 2015 06:51:38 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351441#comment-14351441
] 

Alicia Ying Shu edited comment on PHOENIX-1704 at 3/7/15 6:50 AM:
------------------------------------------------------------------

Correct me if I am wrong, I checked ToDateFunctionIT.java and ToDateFunction.jave,  looks
like Phoenix supports String for To_Time, To_Date, To_Timestamp. 


was (Author: aliciashu):
Correct me if I am wrong, I checked ToDateFunctionIT.java and ToDateFunction.jave,  looks
like Phoenix supports String. 

> 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