From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id KLkyMuhTxGM2nQAAbAwnHQ (envelope-from ) for ; Sun, 15 Jan 2023 20:28:40 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id CDRWMehTxGOlAgAAG6o9tA (envelope-from ) for ; Sun, 15 Jan 2023 20:28:40 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 9B24E28B8B for ; Sun, 15 Jan 2023 20:28:40 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pH8fK-0008A4-55; Sun, 15 Jan 2023 14:27:38 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pH8fI-00089r-Aj for emacs-orgmode@gnu.org; Sun, 15 Jan 2023 14:27:36 -0500 Received: from stw1.rcdrun.com ([217.170.207.13]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pH8fG-0006H2-K6 for emacs-orgmode@gnu.org; Sun, 15 Jan 2023 14:27:36 -0500 Received: from localhost ([::ffff:197.239.8.177]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 0000000000055DAE.0000000063C453A9.00002583; Sun, 15 Jan 2023 12:27:36 -0700 Date: Sun, 15 Jan 2023 22:14:14 +0300 From: Jean Louis To: Tim Cross Cc: Max Nikulin , emacs-orgmode@gnu.org Subject: Re: [FEATURE REQUEST] Timezone support in org-mode datestamps and org-agenda Message-ID: Mail-Followup-To: Tim Cross , Max Nikulin , emacs-orgmode@gnu.org References: <63c30f34.650a0220.498b8.4573@mx.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <63c30f34.650a0220.498b8.4573@mx.google.com> User-Agent: Mutt/2.2.9+54 (af2080d) (2022-11-21) Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN ARC-Seal: i=1; s=key1; d=yhetil.org; t=1673810920; a=rsa-sha256; cv=none; b=BHl2U3LDRogkD+QTtnOLw0pccWXOPnL/KdKAOYjBjDI+g4UdYc7hp5Po2+Zrc5GDpKQRxV Y3tsfsaqlsQHq+wVMuOylGZ5KduX+COKNY5PgWNMswXbvN4s4jKs+lAAuVQrLz0birwZFW 5USg4wYJFiTwcFLcAmZXlpFbldLOdOWCAXJY+vp6HRO3WchGOvTWAkYQBgwyVDVlBgSa+n 2ZFTwsXQCgIzAHRzWumRYh88eGD+0s80Ho6FPAGE78mQgNthbSoH457f52KZJSRD/p5kqM 9WynMcH1nxfrt96S6WmuU5mdBy6w1guTWQIr1bpFRI2Odjsje+XJVhuZUe0lAw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1673810920; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=TTi/1l26uxNUCbAf2UADOKokT3tkVer5Rbocx4KKRr8=; b=Waj8LxbIzWmC4V8JzA0ofOZJ2jhBT2s2//XfwzuwyQN+DMWG3HfVC3/OHDQf21bejX45Do 8izQbpSwN592qoqslGOq97ffVnt7Bc6ZexHQ9jhbbpFzqgl5reeFMWeBgdd6EIGQCbX0xy tALQEW5g3DFuRkAEulSvftSRwmBYp3WMnKYqllrr+vLSw9RodDO8ljW5ZFWQbR5F4+U3EZ 4/KvAhmdONV9UD/A5F0Tk7t3C/l8V/6tXevMNp6BwJhSGBcFiP/ypVkxR2c1uwnuNZnF0b dmn39WYaDCv+lya2DwbabJU7IXC5GaJUK3o5eTAYeyTau4vivq6cP6B4z+ODZQ== X-Migadu-Spam-Score: -2.42 X-Spam-Score: -2.42 X-Migadu-Queue-Id: 9B24E28B8B X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none X-TUID: DBf0WqyJBNbx * Tim Cross [2023-01-14 23:25]: > Yes, this is a problem. We really want a symbolic TZ > specification and we would need 'smarts' i the timestamp generation code > that is able to handle potential offset changes due to daylight savings > transition etc. Even then, the transition time can change between when > the timestamp is set for and when it actually occurs. As PostgreSQL type TIMESTAMP WITH TIME ZONE is stored with underlying UTC time, so should be Org times also be calculated with underlying UTC times. And in that case I just assume that operating system libraries ar handling problem you have stated. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/