You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2019/05/06 12:46:00 UTC

[jira] [Commented] (HIVE-21576) Introduce CAST...FORMAT and limited list of SQL:2016 datetime formats

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

Shawn Weeks commented on HIVE-21576:
------------------------------------

Is there any plan to include fractional seconds. That seems to be consistently missing across all the time stamp functions. 

> Introduce CAST...FORMAT and limited list of SQL:2016 datetime formats
> ---------------------------------------------------------------------
>
>                 Key: HIVE-21576
>                 URL: https://issues.apache.org/jira/browse/HIVE-21576
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Karen Coppage
>            Assignee: Karen Coppage
>            Priority: Major
>         Attachments: HIVE-21576.01.patch
>
>
> Introduce FORMAT clause to CAST statements as well as the below limited list of SQL:2016 datetime formats to Hive in general. These can be used if a session-level feature flag is turned on.
>  * YYYY
>  * MM
>  * DD
>  * HH
>  * MI
>  * SS
> Definitions of these formats here: [https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)