[jira] [Commented] (HIVE-10276) Implement date_format(timestamp, fmt) UDF

["Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>]

    [ 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)