[
https://issues.apache.org/jira/browse/HIVE-10276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696883#comment-14696883
]
Amareshwari Sriramadasu commented on HIVE-10276:
------------------------------------------------
The implementation done here does not look SQL compliant. For ex: D is day of
year in SimpleDateFormat
(https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html),
but is month of the year on SQL :
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format
> Implement date_format(timestamp, fmt) UDF
> -----------------------------------------
>
> Key: HIVE-10276
> URL: https://issues.apache.org/jira/browse/HIVE-10276
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Reporter: Alexander Pivovarov
> Assignee: Alexander Pivovarov
> Fix For: 1.2.0
>
> Attachments: HIVE-10276.01.patch
>
>
> date_format(date/timestamp/string, fmt) converts a date/timestamp/string to a
> value of String in the format specified by the java date format fmt.
> Supported formats listed here:
> https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
