From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id W4b2G0pL1V86PwAA0tVLHw (envelope-from ) for ; Sat, 12 Dec 2020 22:59:22 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id AGFLF0pL1V81WgAAbx9fmQ (envelope-from ) for ; Sat, 12 Dec 2020 22:59:22 +0000 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 CEEE69402A7 for ; Sat, 12 Dec 2020 22:59:21 +0000 (UTC) Received: from localhost ([::1]:56334 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1koDrC-0005dD-JK for larch@yhetil.org; Sat, 12 Dec 2020 17:59:18 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:51452) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1koDqE-0005d3-Bp for emacs-orgmode@gnu.org; Sat, 12 Dec 2020 17:58:18 -0500 Received: from mail-pg1-x529.google.com ([2607:f8b0:4864:20::529]:34421) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1koDqC-0004QQ-MH for emacs-orgmode@gnu.org; Sat, 12 Dec 2020 17:58:18 -0500 Received: by mail-pg1-x529.google.com with SMTP id g18so9866155pgk.1 for ; Sat, 12 Dec 2020 14:58:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=references:user-agent:from:to:subject:date:in-reply-to:message-id :mime-version; bh=SOx0oorJ4fhN8nQNuGfPLtGz02n7q292lJTl53f2EGA=; b=Aows+9t83zKGn86sD5n3CcB34L4j+Og5Rpyu//oMAwPLciBCbCJDGY9tlV+nv4+HB8 Kc82g55OMpa+/HJrBkjuQFTHltbRoYAdCK0/HzK5biU/Z1FMEZ80MKoGJFfVxC7+lIpc XGAAlMer00BVdhZqHl+pue/Mq32EdAN52iuIv24DAkrmbOFbQWFndYNbNzcw6wXw0uKP HmGk5wUOmlm3ZQkZ8kWmOJZsgCUxGueXtbB2Lw4ehGMk9UWVScJ1qXsEZKx/lrKaZw/q GdFUmxwilG/Jz39+8V4D8aFuqNKSgNBQBtBOrcJmOTcuO93ZMkI+jQAodElh/EvgBHYZ mfug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:references:user-agent:from:to:subject:date :in-reply-to:message-id:mime-version; bh=SOx0oorJ4fhN8nQNuGfPLtGz02n7q292lJTl53f2EGA=; b=ULZQZtFVWyq4Usy2XrZ5CT3uL5kNFzmwQHAhzZ/a5qLKrbTbdi+PMj0/keSzRcWN+w enkAga8+VxTxTx+k1Dz/C2t10SclL9Tv315mILFzp0FxKp7XNN5QVlnU8xGHTs0tvva3 VEw/1JKXWQHlMor/xWb2ggcBvP39qlgCm+kq4xvYxZ6tKQQCQqxAZXOzETEBCjXZu1NA r9omyxJY7I3wL2lD4iugRogUxa10biSTBpiBuVvU1ACptqkPIZcZF4M5gH5bALnnvS6G 3mOsgr+B+tz2DqQsgjTYP4Xhk9BRbSXfTlP0tpMtPGCT9A0OCla8SCdLhCUjsytgjdqF dsng== X-Gm-Message-State: AOAM532B/+Y8GqaFrFusx0qmvO2q4oYT/p1sUlyM1FWxeE/FL2uQav3b HhALF2WlOmYMWTYKrEX+hPcgIOjr9J6e2w== X-Google-Smtp-Source: ABdhPJxP/U40XH6WfiJbEijr/nI6JiusGEchjHkzPJTrNVoOaiTr8SivJM+sG+jHLJ2JJRw97h5ZrA== X-Received: by 2002:aa7:8ac1:0:b029:19d:beff:4e0f with SMTP id b1-20020aa78ac10000b029019dbeff4e0fmr17824278pfd.0.1607813894749; Sat, 12 Dec 2020 14:58:14 -0800 (PST) Received: from tim-desktop (220-235-14-99.dyn.iinet.net.au. [220.235.14.99]) by smtp.gmail.com with ESMTPSA id 19sm14769075pfn.133.2020.12.12.14.58.12 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 12 Dec 2020 14:58:14 -0800 (PST) References: <87wnxrjjl2.fsf@gmail.com> <87lfe5ju0t.fsf@gmail.com> User-agent: mu4e 1.5.7; emacs 27.1.50 From: Tim Cross To: emacs-orgmode@gnu.org Subject: Re: org-table change time from UTC to other timezones Date: Sun, 13 Dec 2020 09:52:26 +1100 In-reply-to: Message-ID: <871rfuvdh9.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::529; envelope-from=theophilusx@gmail.com; helo=mail-pg1-x529.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=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.23 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" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -3.00 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=Aows+9t8; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: CEEE69402A7 X-Spam-Score: -3.00 X-Migadu-Scanner: scn1.migadu.com X-TUID: vYoLGCB1mOEa Maxim Nikulin writes: > 2020-12-12 Alan E. Davis wrote: >> >> Thank for the clear explanation. My little problem seems to require a >> super steam hammer. Your insights are most helpful. > > In my opinion, org mode is too rigid in respect to timestamp format. > Sometimes I would prefer to specify timestamps with timezone. > > Well known example of idiosyncrasy of particular applications. > Timestamps in xls files are represented by floating point numbers, > namely days since 1 Jan 1900, fractional part is time. Unfortunately > 1900 is not a leap year, so to avoid unnecessary complications of code > and keep memory footprint small, on Macs epoch starts in 1904, on > windows year 1900 has Feb, 29... Although there are likely some dark corners where bugs can be found, I think you could probably add timezone data to org timestamps by changing the default format strings. Org also uses an 'internal' 'time' value to represent timestamps which are then converted to the required format using these format strings. What is possibly missing is an easy way to specify a time zone when creating a timestamp. I suspect it will default to whatever the local system tz is and I don't think there is any convenient way to change tz values like there is for the other timestamp components. -- Tim Cross