[
https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14364061#comment-14364061
]
Alicia Ying Shu edited comment on PHOENIX-1704 at 3/16/15 10:09 PM:
--------------------------------------------------------------------
[~jamestaylor], [~sergey.b] thanks for the review. In Oracle doc, the syntax
for Year buildin is Year(Date). Uploaded a patch including the following
changes:
1). Added support for UNSIGNED_TIME, UNSIGNED_DATE, UNSIGNED_TIMESTAMP.
2). Added a test case querying against actual column data from a table for
column types: DATE, TIMESTAMP, TIME, UNSIGNED_TIME, UNSIGNED_DATE,
UNSIGNED_TIMESTAMP.
was (Author: aliciashu):
In Oracle doc, the syntax for Year buildin is Year(Date). Uploaded a patch
including the following changes:
1). Added support for UNSIGNED_TIME, UNSIGNED_DATE, UNSIGNED_TIMESTAMP.
2). Added a test case querying against actual column data from a table for
column types: DATE, TIMESTAMP, TIME, UNSIGNED_TIME, UNSIGNED_DATE,
UNSIGNED_TIMESTAMP.
> 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-v2.patch,
> Phoenix-1704-v3.patch, Phoenix-1704-v4.patch
>
>
> Support Year() with date and timestamp.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
