Re: [VOTE] Arrow should state a convention for encoding instants as Timestamp with "UTC" as the time zone

[Neal Richardson <ne...@gmail.com>]

+1

On Wed, Jun 30, 2021 at 9:25 AM Benjamin Kietzman <be...@gmail.com>
wrote:

> +1
>
> On Wed, Jun 30, 2021, 08:54 David Li <li...@apache.org> wrote:
>
> > +1
> >
> > On Wed, Jun 30, 2021, at 08:46, Wes McKinney wrote:
> > > +1
> > >
> > > On Wed, Jun 30, 2021 at 12:03 PM Antoine Pitrou <an...@python.org>
> > wrote:
> > > >
> > > > +1
> > > >
> > > >
> > > > Le 30/06/2021 à 11:52, Weston Pace a écrit :
> > > > > This vote is a result of previous discussion[1][2].  This vote is
> > also
> > > > > a prerequisite for the PR in [5].
> > > > >
> > > > > ---
> > > > > Some date & time libraries have three temporal concepts.  For the
> > sake
> > > > > of this document we will call them LocalDateTime, ZonedDateTime,
> and
> > > > > Instant.  An Instant is a timestamp that has no meaningful
> reference
> > > > > time zone (e.g. events that did not occur on Earth or columns of
> > > > > timestamps spanning more than one time zone). For more extensive
> > > > > definitions and a discussion of their semantics and uses see [3].
> > > > > Currently Arrow describes how to encode two of these three concepts
> > > > > into a Timestamp column and there is no guideline on how to store
> an
> > > > > Instant.
> > > > >
> > > > >
> > > > > This proposal states that Arrow should recommend that instants be
> > encoded
> > > > > into timestamp columns by setting the timezone string to "UTC".
> > > > > ---
> > > > >
> > > > > For sample arguments (currently grouped as "for changing
> schema.fbs"
> > > > > and "against changing schema.fbs") see [4].  For a detailed
> > definition
> > > > > of the terms LocalDateTime, ZonedDateTime, and Instant and a
> > > > > discussion of their semantics see [3].  For a straw poll on
> > > > > possible ways to handle instants see [2].
> > > > >
> > > > > This vote will be open for at least 72 hours.
> > > > >
> > > > > [ ] +1 Update schema.fbs to state the above convention
> > > > > [ ] +0
> > > > > [ ] -1 Do not make any change
> > > > >
> > > > > [1]
> >
> https://lists.apache.org/thread.html/r8216e5de3efd2935e3907ad9bd20ce07e430952f84de69b36337e5eb%40%3Cdev.arrow.apache.org%3E
> > > > > [2]
> >
> https://lists.apache.org/thread.html/r1bdffc76537ae9c12c37396880087fee9c0eec9000bf6ed4c9850c44%40%3Cdev.arrow.apache.org%3E
> > > > > [3]
> >
> https://docs.google.com/document/d/1QDwX4ypfNvESc2ywcT1ygaf2Y1R8SmkpifMV7gpJdBI/edit?usp=sharing
> > > > > [4]
> >
> https://docs.google.com/document/d/1xEKRhs-GUSMwjMhgmQdnCNMXwZrA10226AcXRoP8g9E/edit?usp=sharing
> > > > > [5] https://github.com/apache/arrow/pull/10629
> > > > >
> > >
>