You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Karen Coppage (Jira)" <ji...@apache.org> on 2020/01/23 08:53:00 UTC

[jira] [Assigned] (HIVE-22763) 0 is accepted in 12-hour format during timestamp cast

     [ https://issues.apache.org/jira/browse/HIVE-22763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karen Coppage reassigned HIVE-22763:
------------------------------------


> 0 is accepted in 12-hour format during timestamp cast
> -----------------------------------------------------
>
>                 Key: HIVE-22763
>                 URL: https://issues.apache.org/jira/browse/HIVE-22763
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>            Reporter: Karen Coppage
>            Assignee: Karen Coppage
>            Priority: Minor
>             Fix For: 4.0.0
>
>
> Having a timestamp string in 12-hour format can be parsed if the hour is 0, however, based on the [design document|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit], it should be rejected.
> h3. How to reproduce
> Run {code}select cast("2020-01-01 0 am 00" as timestamp format "yyyy-mm-dd hh12 p.m. ss"){code}
> It shouldn' t be parsed, as the hour component is 0.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)