Sample Header Ad - 728x90

MySQL - Turkey/Istanbul Daylight Saving Time Change

0 votes
1 answer
767 views
Until this year Turkey was using daylight saving time, staying UTC+2 on winter period, UTC+3 on summer. This year it is decided to stay only in UTC+3. Our DateTime's are persisted on MySQL (5.26.34) db (on AWS) was using UTC timezone. When i try to use CONVERT_TZ(DateTime, UTC, EUROPE/ISTANBUL) for recent datetime -lets say- 2016-11-21 00:00 it tries to convert according to UTC+2, whereas it suppose to be UTC+3. When i would tried to convert 2015-11-21 00:00 -last year- it suppose to convert according to UTC+2, since Turkey was in UTC+2 at that time. I Found an announcement on AWS forum, advicing to use Moscow timezone, which is not an option for us since Turkey's timezone situation is unique and our DateTime's are saved in the form of UTC0. https://forums.aws.amazon.com/ann.jspa?annID=4115
Asked by ayyayyekokojambo (101 rep)
Nov 21, 2016, 11:56 AM
Last activity: Feb 22, 2025, 12:07 AM