[SPARK-37552] Add the convert_timezone() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Epic Link: New functions in Spark SQL 3.3
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 05/Dec/21 18:33
• Updated: 04/Apr/22 09:22
• Resolved: 06/Dec/21 09:46

Description

CONVERT_TIMEZONE is a common SQL function provided by many other database systems, e.g.

1. https://docs.aws.amazon.com/redshift/latest/dg/CONVERT_TIMEZONE.html
2. https://docs.snowflake.com/en/sql-reference/functions/convert_timezone.html

The ticket aims to support such function in Spark SQL to make migration from other systems easier.

Issue Links

• causes: SPARK-37568 Support 2-arguments by the convert_timezone() function
• links to: [Github] Pull Request #34817 (MaxGekk)