Autonomous Database and timezone

Nov 27, 2019 4:32PM

Summary

how to change a timezone in an Autonomous Database

i use the parameter TIME_ZONE but the value don't change

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL>
SQL> select to_char(sysdate,'dd.mm.yyyy hh24:mi') from dual;

TO_CHAR(SYSDATE,
----------------
27.11.2019 16:20

SQL>ALTER DATABASE SET TIME_ZONE = '+01:00';

shutdown

startup

SQL> select to_char(sysdate,'dd.mm.yyyy hh24:mi') from dual;

TO_CHAR(SYSDATE,
----------------
27.11.2019 16:25

SQL>

18c