[ 
https://issues.apache.org/jira/browse/HIVE-10276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14486698#comment-14486698
 ] 

Alexander Pivovarov commented on HIVE-10276:
--------------------------------------------

{code}
dayname(date)
// can be replaced with
to_char(date, 'EEEE')
{code}

In the case when 3 chars day name needed 'EEE' fmt can be used.

> Implement to_char(timestamp, fmt) UDF
> -------------------------------------
>
>                 Key: HIVE-10276
>                 URL: https://issues.apache.org/jira/browse/HIVE-10276
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Alexander Pivovarov
>            Assignee: Alexander Pivovarov
>
> to_char(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)

Reply via email to