oracle timezone

In this blog, We are going to see how to change DBTime zone in multitenent database. Oracle recommends setting the database time zone to UTC (0:00), as no conversion of time zones will be required. CDB LevelSQL> SELECT DBTIMEZONE FROM dual;DBTIME——+00:00SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’;Database altered.SQL> SELECT dbtimezone FROM DUAL;DBTIME—— — > No change. Bounce […]