From owner-freebsd-questions@freebsd.org Fri Mar 26 20:58:59 2021 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 5CCFB5AC17F for ; Fri, 26 Mar 2021 20:58:59 +0000 (UTC) (envelope-from bferrell@baywinds.org) Received: from baywinds.org (50-196-187-248-static.hfc.comcastbusiness.net [50.196.187.248]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "baywinds.org", Issuer "rr-v" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 4F6Z8L2dKCz3jxb for ; Fri, 26 Mar 2021 20:58:57 +0000 (UTC) (envelope-from bferrell@baywinds.org) Received: from [192.0.2.130] (rr-iii [192.0.2.130]) by baywinds.org (8.14.4/8.14.4) with ESMTP id 12QKwt7b010568 for ; Fri, 26 Mar 2021 13:58:55 -0700 Subject: Re: mysql time-zone ambiguity? To: freebsd-questions@freebsd.org References: <80c1be90-8780-6cb9-36aa-1dc4e22ccfaf@dreamchaser.org> <6cc15ffb-8941-27bd-e9ef-b4960c4ed303@baywinds.org> <77f7f2fa-6cca-f24a-4a69-f88a0aab161d@panix.com> From: Bruce Ferrell Message-ID: Date: Fri, 26 Mar 2021 13:58:55 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.11.0 MIME-Version: 1.0 In-Reply-To: <77f7f2fa-6cca-f24a-4a69-f88a0aab161d@panix.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Greylist: inspected by milter-greylist-4.5.12 (baywinds.org [192.0.2.134]); Fri, 26 Mar 2021 13:58:55 -0700 (PDT) for IP:'192.0.2.130' DOMAIN:'rr-iii' HELO:'[192.0.2.130]' FROM:'bferrell@baywinds.org' RCPT:'' X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.5.12 (baywinds.org [192.0.2.134]); Fri, 26 Mar 2021 13:58:55 -0700 (PDT) X-Rspamd-Queue-Id: 4F6Z8L2dKCz3jxb X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=pass (mx1.freebsd.org: domain of bferrell@baywinds.org designates 50.196.187.248 as permitted sender) smtp.mailfrom=bferrell@baywinds.org X-Spamd-Result: default: False [-2.23 / 15.00]; RCVD_TLS_LAST(0.00)[]; RBL_DBL_DONT_QUERY_IPS(0.00)[50.196.187.248:from]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; TO_DN_NONE(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; SPAMHAUS_ZRD(0.00)[50.196.187.248:from:127.0.2.255]; ARC_NA(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.93)[-0.928]; DMARC_NA(0.00)[baywinds.org]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:7922, ipnet:50.128.0.0/9, country:US]; SUBJECT_ENDS_QUESTION(1.00)[]; MAILMAN_DEST(0.00)[freebsd-questions]; RCVD_COUNT_TWO(0.00)[2] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 26 Mar 2021 20:58:59 -0000 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!