[
https://issues.apache.org/jira/browse/HIVE-10399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15154932#comment-15154932
]
Aihua Xu commented on HIVE-10399:
---------------------------------
[~azeroth2b] You can use e.g., {{select date_format(cast(123.123 as timestamp),
'dd-MM-yyyy HH:mm:ss SSSSS');}} to get custom format you want.
> from_unixtime_millis() Hive UDF
> -------------------------------
>
> Key: HIVE-10399
> URL: https://issues.apache.org/jira/browse/HIVE-10399
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Environment: HDP 2.2
> Reporter: Hari Sekhon
> Priority: Minor
>
> Feature request for a
> {code}from_unixtime_millis(){code}
> Hive UDF - from_unixtime() accepts only secs since epoch, and right now the
> solution is to create a custom UDF, but this seems like quite a standard
> thing to support millisecond precision dates in Hive natively.
> Hari Sekhon
> http://www.linkedin.com/in/harisekhon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
