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.

1개 답변
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
전문가
답변함 10달 전
  • 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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠