Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Autonomous Database and timezone — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Autonomous Database and timezone

Received Response
15
Views
4
Comments
edited Apr 16, 2022 7:56AM in Autonomous Database 4 comments

Summary

how to change a timezone in an Autonomous Database

Content

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>

 

Version

18c

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!