current_timezone function
Applies to: 
Databricks SQL Databricks Runtime
Returns the current session local timezone.
Syntax
current_timezone()
Arguments
This function takes no arguments.
Returns
A STRING.
Examples
> SELECT current_timezone();
Asia/Shanghai