mysql time-zone ambiguity?

[Bruce Ferrell]

On 3/26/21 1:26 PM, Kurt Hackenberg wrote:
> On 2021/03/26 14:11, Bruce Ferrell wrote:
>
>> The thing that ALWAYS works for setting the time zone is to manually set it as the offset and never use symbolics in the options file:
>>
>> default-time-zone='+0700'
>
> That doesn't look like it handles daylight saving time.
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> https://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"


Did I say it dealt with DST? This is why, when I set up an enterprise instance, I try to set for UTC and make the developers adjust for the users locale in the application... 
Sometimes I get away with it.

:-)

There is a discussion of DST rules and named timezone support in the mysql documentation.  I'll put the link for v5.7 below as it's kind of long to paste below.  It's more or less 
the same with minor changes for various versions:

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

It also mentions that once one starts doing this one needs to be aware of the fact that DST rules DO change periodically and the tables for that support need to be updated 
accordingly.... One more thing to keep up to date!