[
https://issues.apache.org/jira/browse/PHOENIX-1704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351859#comment-14351859
]
James Taylor commented on PHOENIX-1704:
---------------------------------------
Ok - let's build those so that they accept date/time types, not strings.
[~sergey.b] - yes, I was thinking that underneath EXTRACT could easily be built
on top of the same code as FLOOR, but only for those cases where we don't need
to convert to Joda time (second, minute, hour, day where you can just do simple
math on the Epoch time). For month, quarter, and year, I think we'd need to go
from epoch time to Joda time and then use Joda APIs to extract these.
> 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)
