oracle-databasetimezoneoracle-apexoracle-cloud-infrastructureoracle-autonomous-db

change timezone in ORACLE autonomous database


I want to use oracle cloud autonomous database but not able to see time in IST Timezone.

Is there any way to change timezone from UTC to IST at system level in oracle autonomous database in oracle cloud?

Or any workaround available for autonomous database for apex instance.

Thanks, Yagnik


Solution

  • You can use the "alter database set time_zone" command and restart the database to change the timezone. Note that if you are using sysdate and systimestamp, those will still return in UTC. You can use the sysdate_at_dbtimezone parameter to make them return in the database timezone you set.

    See this doc, https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-initialization-parameters.html#GUID-1D5E830F-2986-4E6C-AF8F-899AC3C85D07, for further information.