Karen Coppage created HIVE-22763:
------------------------------------
Summary: 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
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)
