You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/04/09 19:32:12 UTC

[jira] [Commented] (HIVE-3299) Create UDF DAYNAME(date)

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

Alexander Pivovarov commented on HIVE-3299:
-------------------------------------------

the function can be replaced by
{code}
date_format(date, 'EEEE')
{code}

> Create UDF  DAYNAME(date)
> -------------------------
>
>                 Key: HIVE-3299
>                 URL: https://issues.apache.org/jira/browse/HIVE-3299
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>    Affects Versions: 0.9.0
>            Reporter: Namitha Babychan
>            Assignee: Alexander Pivovarov
>              Labels: patch
>         Attachments: HIVE-3299.1.patch.txt, HIVE-3299.2.patch, HIVE-3299.3.patch, HIVE-3299.4.patch, HIVE-3299.patch.txt, Hive-3299_Testcase.doc, udf_dayname.q, udf_dayname.q.out
>
>
> dayname(date/timestamp/string)
> Returns the name of the weekday for date. The language used for the name is English.
> select dayname('2015-04-08');
> Wednesday



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)