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)