Changing the time zone can be found here:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.html
Near the bottom you will find this:
Setting the Database Time Zone
Near the bottom you will find this:
Setting the Database Time Zone
You can alter the time zone of a database by running the rdsadmin_util procedure as shown in the following table. You can use any time zone name or GMT offset that is accepted by Oracle.
Oracle Method | Amazon RDS Method |
---|---|
alter database set time_zone = '+3:00'; | exec rdsadmin.rdsadmin_util.alter_db_time_zone('+3:00'); |
After you alter the time zone, you must reboot the DB Instance for the change to take effect.
There are additional restrictions on setting time zones listed in the Oracle documentation.
Exchange Server online training
ReplyDeleteGoogle Cloud online training
IBM Intergration Bus online training
IBM Message Queue online training
Install shield online training
Kubernetes online training
Linux Admin online training
Linux online training
Load runner online training
MSBI online training
Mule ESB online training