hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6046) add UDF for converting date time from one presentation to another
Date Mon, 18 May 2015 20:54:00 GMT

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

Alexander Pivovarov commented on HIVE-6046:
-------------------------------------------

date_format UDF was added recently HIVE-10276. It accepts hive date/timestamp/string and converts
it to string
{code}
hive> select date_format('2013-12-12 00:00:00.0', 'yyyy/MM/dd');
OK
2013/12/12
{code}
[~kostiantyn] Should we close this ticket?

> add  UDF for converting date time from one presentation to another
> ------------------------------------------------------------------
>
>                 Key: HIVE-6046
>                 URL: https://issues.apache.org/jira/browse/HIVE-6046
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>    Affects Versions: 0.13.0
>            Reporter: Kostiantyn Kudriavtsev
>            Assignee: Kostiantyn Kudriavtsev
>         Attachments: HIVE-6046.patch, Hive-6046-Feb15.patch, Hive-6046.patch
>
>
> it'd be nice to have function for converting datetime to different formats, for example:
> format_date('2013-12-12 00:00:00.0', 'yyyy-MM-dd HH:mm:ss.S', 'yyyy/MM/dd')
> There are two signatures to facilitate further using:
> format_date(datetime, fromFormat, toFormat)
> format_date(timestamp, toFormat)
>  



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

Mime
View raw message