[
https://issues.apache.org/jira/browse/HIVE-345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15647129#comment-15647129
]
Naveen Kumar Mahadevuni commented on HIVE-345:
----------------------------------------------
Hi. I'm starting as a contributor. I would like to work on this. Is anyone else
working on similar changes? HIVE-6009, HIVE-2867 and HIVE-6040 are also related
to this.
> Extend Date UDFs to support time zone and full specs as in MySQL
> ----------------------------------------------------------------
>
> Key: HIVE-345
> URL: https://issues.apache.org/jira/browse/HIVE-345
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Affects Versions: 0.3.0
> Reporter: Zheng Shao
> Assignee: Mark Grover
>
> Most of the Date UDF in Hive now are based on String instead of Date objects,
> and they have limited functionality compared with MySQL.
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-sub
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff
> We should make it fully compliant with what MySQL offers.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
