[
https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14350996#comment-14350996
]
Jeffrey Zhong commented on PHOENIX-1704:
----------------------------------------
Looks good to me(+1). Could you also add test cases for following date format
string? Thanks. [~gabriel.reid], [~jamestaylor] could you also take a look?
Thanks.
2015-03-04
2015-03-04T12:43:20+00:00
2015-03-04T12:43:20Z
2015-W10
2015-W10-3
2015-063
> 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.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)
