From: "Alan E. Davis" <email@example.com>
To: Tim Cross <firstname.lastname@example.org>
Cc: org-mode <email@example.com>
Subject: Re: org-table change time from UTC to other timezones
Date: Sat, 12 Dec 2020 19:14:32 -0800 [thread overview]
Message-ID: <CAF-1L2SYAO10zu6uWSgU_M637cWaTD8Rfh88yFT8R-6TR0GaDw@mail.gmail.com> (raw)
[-- Attachment #1: Type: text/plain, Size: 1941 bytes --]
Thank for the ideas. The 'date' command examples look interesting.
I think R would not be too unwieldy as a hammer here. My use case is a
humble one: just take a several clock times in HH:MM format (utc) and
adjust to another timezone by adding or subtracting the relevant number of
hours. The day of week is not important; i will have to deal with it. I
did imagine a conditional subtraction by adding of subtracting 24:00 as
Much thanks for the advice.
On Sat, Dec 12, 2020, 15:00 Tim Cross <firstname.lastname@example.org> wrote:
> Maxim Nikulin <email@example.com> 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
[-- Attachment #2: Type: text/html, Size: 2699 bytes --]
next prev parent reply other threads:[~2020-12-13 3:15 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2020-12-09 10:20 org-table change time from UTC to other timezones Alan E. Davis
2020-12-09 11:34 ` Tim Cross
2020-12-10 8:10 ` Alan E. Davis
2020-12-10 19:01 ` Tim Cross
2020-12-11 0:12 ` Alan E. Davis
2020-12-11 15:40 ` Maxim Nikulin
2020-12-11 22:44 ` Alan E. Davis
2020-12-12 16:04 ` Maxim Nikulin
2020-12-12 22:52 ` Tim Cross
2020-12-13 3:14 ` Alan E. Davis [this message]
2020-12-13 17:03 ` Maxim Nikulin
2020-12-14 2:29 ` Alan E. Davis
2020-12-12 3:31 ` Jean Louis
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).