[ https://issues.apache.org/jira/browse/HIVE-25056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Shekhar reassigned HIVE-25056: ------------------------------------- > cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion > ------------------------------------------------------------------------------ > > Key: HIVE-25056 > URL: https://issues.apache.org/jira/browse/HIVE-25056 > Project: Hive > Issue Type: Bug > Reporter: Anurag Shekhar > Assignee: Anurag Shekhar > Priority: Minor > > 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| > +--------------+-----------------------+ -- This message was sent by Atlassian Jira (v8.3.4#803005)