[ https://issues.apache.org/jira/browse/HIVE-21743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892845#comment-16892845 ]
Adarshdeep Cheema commented on HIVE-21743: ------------------------------------------ This function works fine for all the dates after 1582-10-15 (including) in 1582 The Roman calendar was changed to the Georgian calendar. > 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.1 > Environment: Server: Apache Hive 3.1 > Driver hive-jdbc-3.1.0.3.1.0.0-78 > Reporter: Adarshdeep Cheema > Priority: Critical > > Using Apache Hive 3.1 server //// > Run the following SQL and you will get 3 instead of 1 > SELECT > (day( DATE '0001-01-01')) > FROM > `table` > PLEASE NOTE THIS DOES NOT HAPPEN WITH Apache HIVE 2.1 SERVER -- This message was sent by Atlassian JIRA (v7.6.14#76016)