By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

time zone issue in MySQL Aurora Instance

0

time_zone in the parameter group is Asia/Calcutta but still, schedule events in the database are running according to UTC time not according to UTC+5:30

SELECT @@global.time_zone is also returning Asia/Calcutta.

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabaseAmazon AuroraAurora MySQLMySQL
Language
English
ani8
asked 9 months ago232 views
1 Answer
0

Hello.
Did you follow these instructions to edit the cluster parameter group?
Also, did you reboot after editing?
https://repost.aws/knowledge-center/aurora-mysql-change-timezone

profile picture
EXPERT
Riku_Kobayashi
answered 9 months ago
  • ani8
    9 months ago

    yes, I did and also rebooted the instance a couple of times, but still no effect. As mentioned both @@global.time_zone and @@session.time_zone are showing "Asia/Calcutta" but still scheduled events take timestamp of UTC.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content