How do I change the time zone of my Amazon RDS DB instance?

Last updated: 2019-11-15

I want to change the time zone of my Amazon Relational Database Service (Amazon RDS) DB instance to the local time zone. How do I change the time zone of my DB instance?

Short Description

All Amazon RDS DB instances use UTC/GMT time by default, and changing your time zone is optional. We strongly recommend using UTC time zone at the database layer, but if you must use a local time zone, always convert the time zone at the application layer. Before changing your time zone, consult your database administrator or application team.

Resolution

The steps required to modify the time zone of an Amazon RDS DB instance vary depending on the database engine.

Oracle – To modify the time zone for Amazon RDS Oracle DB instances, see Setting the Database Time Zone. To change the time zone, Oracle Database Engine version 11.2.0.2.v4 is required.

PostgreSQL – To modify the time zone for Amazon RDS PostgreSQL DB instances at the database level, set the value of the time zone parameter in a custom parameter group. The time zone parameter takes the input form of UTC-X or UTC+X, where X is the number of hours that the time zone should be offset from UTC time.

Important: PostgreSQL processes time zones differently if they are referenced as UTC-5 vs "America/New_York". For example, the time zone "America/New_York" will display UTC-5. If you set the time zone as UTC-5, it will update as UTC+5. For more information, see the PostgreSQL documentation for Date/Time Types.

MySQL – To change the time zone of a DB instance that runs MySQL 5.5, 5.6, or 5.7, set the time_zone parameter in the DB parameter group for the DB instance. All DB instances and read replicas that use the parameter group will change to use the new time zone. You can't change the time zone for Amazon RDS MySQL versions prior to 5.5. By default, the time zone for RDS MySQL DB instances is Coordinated Universal Time (UTC). For more information, see Local Time Zone for MySQL DB Instances.

Amazon Aurora – To change the time zone for an Amazon Aurora DB cluster, see Local Time Zone for Amazon Aurora DB Clusters.

MariaDB – To change the time zone for a DB instance that runs MariaDB, set the time_zone parameter in the DB parameter group for the DB instance. All DB instances and read replicas that use the parameter group will change to use the new time zone. By default, the time zone for RDS MariaDB DB instances is Coordinated Universal Time (UTC). For more information, see Local Time Zone for MariaDB DB Instances.

SQL Server – To change the time zone, specify the time zone when creating a new Amazon RDS for SQL Server instance. When creating the DB instance, expand the Additional configuration section, and choose your preferred time zone from the Time zone menu. The time zone can't be modified after the instance is created. For more information, see Local Time Zone for Microsoft SQL Server DB Instances.


Did this article help you?

Anything we could improve?


Need more help?