Adjusting for the default time-zone setting on RDS

Question

We recently switched to an RDS instance and noticed that bunch of our database tasks were getting triggered 4 hours earlier than needed. On investigating further, the problem is caused by the default time-zone setting (UTC) on the RDS instance. Since this setting can not be altered, we would like to fix the issue on the code level globally across all our applications using this database instance. I tried to set the time-zone on the db instance I create to 'US/Eastern' by using

set GLOBAL time_zone = 'US/Eastern'" OR
set time_zone = 'US/Eastern'"

But that generates an error "Database error: Unknown or incorrect time zone: 'US/Eastern'"

What do you think I am doing wrong here? Does anyone has used any other solutions ?

Answer 1

I did the following steps, So that I could change the timezone

1. login to RDS and Create New Parameter Group.

2. Edit the newly created Parameter Group

3. Set timezone Ex:Asia/Calcutta and Save Changes

4. Modify RDS instance, change DB's Parameter Group to newly created parameter group

5. Save And Reboot RDS instance

Answer 2

The time_zone setting of RDS database instances can now be modified: https://aws.amazon.com/de/premiumsupport/knowledge-center/rds-change-time-zone/