Returns the time zone of the current project.
Syntax
STRING CURRENT_TIMEZONE()
Arguments
This function takes no arguments.
Return value
Returns a STRING value representing the current project's time zone.
Examples
Example 1: Get the current project time zone
SELECT CURRENT_TIMEZONE();
-- Returns Asia/Shanghai.
Example 2: Get the time zone after changing the project time zone to UTC
-- Change the project time zone to UTC.
SET odps.sql.timezone=Etc/GMT;
SELECT CURRENT_TIMEZONE();
-- Returns Etc/GMT.
Related functions
CURRENT_TIMEZONE is a date function. For more information about functions related to date calculation and conversion, see Date functions.