Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 26 Mar 2021 13:58:55 -0700
From:      Bruce Ferrell <bferrell@baywinds.org>
To:        freebsd-questions@freebsd.org
Subject:   Re: mysql time-zone ambiguity?
Message-ID:  <a9d6bfa8-c282-58a7-a67c-ad38c03a1e6f@baywinds.org>
In-Reply-To: <77f7f2fa-6cca-f24a-4a69-f88a0aab161d@panix.com>
References:  <dba947d1-c5bd-b732-55da-4651d9297dff@dreamchaser.org> <bfc8b528-8af0-2d13-7294-0095549ffd25@baywinds.org> <80c1be90-8780-6cb9-36aa-1dc4e22ccfaf@dreamchaser.org> <6cc15ffb-8941-27bd-e9ef-b4960c4ed303@baywinds.org> <77f7f2fa-6cca-f24a-4a69-f88a0aab161d@panix.com>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
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@freebsd.org mailing list
> https://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@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!






Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?a9d6bfa8-c282-58a7-a67c-ad38c03a1e6f>