Adarshdeep Cheema created HIVE-21743: ----------------------------------------
Summary: day( ) gives wrong day from the date in Apache Hive 3.1 server Key: HIVE-21743 URL: https://issues.apache.org/jira/browse/HIVE-21743 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 3.0.0 Environment: Server: Apache Hive 3.1 Driver hive-jdbc-3.1.0.3.1.0.0-78 Reporter: Adarshdeep Cheema Fix For: 3.1.2 Using Apache Hive 3.1 server //// Run the following SQL and you will get 3 instead of i. SELECT (day( DATE '0001-01-01')) FROM `tabke` PLEASE NOTE THIS DOES NOT HAPPEN WITH Apache HIVE 2.1 SERVER -- This message was sent by Atlassian JIRA (v7.6.3#76005)