[SPARK-37568] Support 2-arguments by 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, 3.4.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 07/Dec/21 12:51
• Updated: 24/Mar/22 14:39
• Resolved: 24/Mar/22 07:57

Description

1. If sourceTs is a timestamp_ntz, take the sourceTz from the session time zone, see the SQL config spark.sql.session.timeZone
2. If sourceTs is a timestamp_ltz, convert it to a timestamp_ntz using the targetTz

Issue Links

• is caused by: SPARK-37552 Add the convert_timezone() function
• links to: [Github] Pull Request #34896 (yoda-mon)
• links to: [Github] Pull Request #35951 (MaxGekk)
• links to: [Github] Pull Request #35957 (MaxGekk)
• links to: [Github] Pull Request #35957 (MaxGekk)