1回答
- 新しい順
- 投票が多い順
- コメントが多い順
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.
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 10ヶ月前
- AWS公式更新しました 3年前
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.