[SPARK-32272] SET TIME ZONE standard sql command support

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 10/Jul/20 11:00
• Updated: 16/Jul/20 13:02
• Resolved: 16/Jul/20 13:02

Description

Function
Set the current default time zone displacement for the current SQL-session.
Format
<set local time zone statement> ::=
SET TIME ZONE <set time zone value>
<set time zone value> ::=
<interval value expression>
| LOCAL

Syntax Rules
1) The declared type of the <interval value expression> immediately contained in the <set time zone value> shall be INTERVAL HOUR TO MINUTE.

Issue Links

• links to: [Github] Pull Request #29064 (yaooqinn)