[SPARK-20763] The function of `month` and `day` return a value which is not we expected

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.0, 2.2.0
• Fix Version/s: 2.2.0
• Component/s: SQL
• Assignee: liuxian
• Reporter: liuxian
• Created: 16/May/17 09:04
• Updated: 22/May/17 04:18
• Resolved: 19/May/17 17:27

Description

spark-sql>select month("1582-09-28");
spark-sql>10
For this case, the expected result is 9, but it is 10.

spark-sql>select day("1582-04-18");
spark-sql>28
For this case, the expected result is 18, but it is 28.

Issue Links

• links to: [Github] Pull Request #17997 (10110346)
• links to: [Github] Pull Request #18053 (10110346)
• links to: [Github] Pull Request #18054 (10110346)