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