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-6214) Need a UDF to convert a Date String from any standard format to another. Should be able to provide the Date String, current format and to the format into which it need to be converted and returned as String output of UDF
Date Mon, 18 May 2015 20:56:00 GMT

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

Alexander Pivovarov commented on HIVE-6214:
-------------------------------------------

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


> Need a UDF to convert a Date String from any standard format to another. Should be able
to provide the Date String, current format and to the format into which it need to be converted
and returned as String output of UDF
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-6214
>                 URL: https://issues.apache.org/jira/browse/HIVE-6214
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>         Environment: Software
>            Reporter: Rony Pius Manakkal
>            Priority: Minor
>              Labels: features
>
> Need a UDF to convert a Date String from any standard format to another. Should be able
to provide the Date String, current format and to the format into which it need to be converted
and returned as String output of UDF
> Example : String convertDateFormat(String dateString, String currentDateFormat, String
requiredFormat);



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

Mime
View raw message