[HIVE-25056] cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Labels: pull-request-available
• Assignee: Anurag Shekhar
• Reporter: Anurag Shekhar
• Created: 26/Apr/21 07:35
• Updated: 03/Sep/21 00:09
• Resolved: 26/Jul/21 05:03

Description

select cast ('0000-00-00' as date) , cast ('000-00-00 00:00:00' as timestamp) 

-----------------------------------+

_c0

_c1

-----------------------------------+

0002-11-30

0002-11-30 00:00:00.0

-----------------------------------+

Issue Links

• relates to: HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT
• links to: GitHub Pull Request #2221