1 Answer
- Newest
- Most votes
- Most comments
0
Hi there.
I don't believe you can do that with RDS as those are managed instances. You can, instead, change the timezone:
For a DB instance running MySQL 5.5, 5.6, 5.7, and 8.0 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 change to use the new time zone. You can't change the time zone for Amazon RDS for MySQL versions prior to 5.5. By default, the time zone for RDS for MySQL DB instances is Coordinated Universal Time (UTC). For more information, see Local time zone for MySQL DB instances.
I hope this helps.
Relevant content
- Accepted Answerasked a year ago
AWS OFFICIALUpdated 8 months ago- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 3 years ago
Thank you Jose, the time zone is already configured in the parameter group and I see the correct time zone in rds, the problem is that the America/Monterrey time zone is using UTC-5 and not UTC-6 as it should be.
mysql> SELECT @@global.time_zone, @@session.time_zone; +--------------------+---------------------+ | @@@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | America/Monterrey | | America/Monterrey | +--------------------+---------------------+ 1 row in set (0.00 sec)
mysql> SELECT current_timestamp(); +---------------------+ | current_timestamp() | +---------------------+ | 2023-07-05 14:13:39 | +---------------------+ 1 row in set (0.00 sec)
That's something that will probably have to come from the RDS team, I'm afraid.