The CURRENT_TIMEZONE function returns the time zone of the current project.
Syntax
STRING CURRENT_TIMEZONE()
-- A standard example.
-- Returns Asia/Shanghai.
SELECT CURRENT_TIMEZONE();Return value
Returns a value of the STRING type.
Examples
-- Returns Asia/Shanghai.
SELECT CURRENT_TIMEZONE();
-- Change the project time zone to UTC.
SET odps.sql.timezone=Etc/GMT;
-- Returns Etc/GMT.
SELECT CURRENT_TIMEZONE();Related functions
CURRENT_TIMEZONE is a date function. For more information about functions related to date calculation and conversion, see Date functions.