Adrian Klaver wrote:
> On 4/16/20 1:23 AM, raf wrote:
> > Steve Baldwin wrote:
> >
> > > I'm pretty sure you are mistaken. Postgres doesn't store the 'creating'
> > > time zone in a timestamptz column.
> > >
> > > Try doing this before re-running your test:
> > >
> > > set timezone to 'utc';
>
On 4/16/20 1:23 AM, raf wrote:
Steve Baldwin wrote:
I'm pretty sure you are mistaken. Postgres doesn't store the 'creating'
time zone in a timestamptz column.
Try doing this before re-running your test:
set timezone to 'utc';
What you are seeing in your test is an artifact of that timezone s
Fra: Magnus Hagander
Sendt: 16. april 2020 10:28
Til: Niels Jespersen
Cc: pgsql-general@lists.postgresql.org
Emne: Re: timestamp and timestamptz
On Thu, Apr 16, 2020 at 6:12 AM Niels Jespersen
mailto:n...@dst.dk>> wrote:
Fra: Magnus Hagander mailto:mag...@hagander.net>>
Send
On Thu, Apr 16, 2020 at 6:12 AM Niels Jespersen wrote:
>
>
>
>
> *Fra:* Magnus Hagander
> *Sendt:* 15. april 2020 20:05
> *Til:* Niels Jespersen
> *Cc:* pgsql-general@lists.postgresql.org
> *Emne:* Re: timestamp and timestamptz
>
>
>
>
>
>
>
&
Steve Baldwin wrote:
> I'm pretty sure you are mistaken. Postgres doesn't store the 'creating'
> time zone in a timestamptz column.
>
> Try doing this before re-running your test:
>
> set timezone to 'utc';
>
> What you are seeing in your test is an artifact of that timezone setting.
>
> Steve
čt 16. 4. 2020 v 9:19 odesílatel raf napsal:
> David G. Johnston wrote:
>
> > On Wed, Apr 15, 2020 at 4:53 PM raf wrote:
> >
> > > I don't see much difference in storing a timestamptz in UTC or a
> > > timestamptz
> > > in CET. As long as the intended offset from UTC is recorded (which it
> is
>
I'm pretty sure you are mistaken. Postgres doesn't store the 'creating'
time zone in a timestamptz column.
Try doing this before re-running your test:
set timezone to 'utc';
What you are seeing in your test is an artifact of that timezone setting.
Steve
On Thu, Apr 16, 2020 at 5:19 PM raf wro
David G. Johnston wrote:
> On Wed, Apr 15, 2020 at 4:53 PM raf wrote:
>
> > I don't see much difference in storing a timestamptz in UTC or a
> > timestamptz
> > in CET. As long as the intended offset from UTC is recorded (which it is
> > in a timestamptz) it should be fine.
>
> I only really sk
Fra: Magnus Hagander
Sendt: 15. april 2020 20:05
Til: Niels Jespersen
Cc: pgsql-general@lists.postgresql.org
Emne: Re: timestamp and timestamptz
On Wed, Apr 15, 2020 at 7:50 PM Niels Jespersen
mailto:n...@dst.dk>> wrote:
Hello all
We have some data that have entered a timestamp
On Wed, Apr 15, 2020 at 4:53 PM raf wrote:
> I don't see much difference in storing a timestamptz in UTC or a
> timestamptz
> in CET. As long as the intended offset from UTC is recorded (which it is
> in a timestamptz) it should be fine.
>
I only really skimmed the entire response but this frami
Tim Cross wrote:
> Niels Jespersen writes:
>
> > Hello all
> >
> > We have some data that have entered a timestamp column from a csv. The data
> > in the csv are in utc. We want to access the data in
> > our native timezone (CET).
> >
> > I am considering a few alternatives:
> >
> > 1.
Niels Jespersen writes:
> Hello all
>
>
>
> We have some data that have entered a timestamp column from a csv. The data
> in the csv are in utc. We want to access the data in
> our native timezone (CET).
>
>
>
> I am considering a few alternatives:
>
>
>
> 1. Early in the process
On Wed, Apr 15, 2020 at 11:06 AM Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> What is the exact format of the timestamp in the CSV? As long as it is in
> a "fully qualified" format, i.e. includes the time-zone offset, then you
> will have no problem as the data represents a point in t
What is the exact format of the timestamp in the CSV? As long as it is in a
"fully qualified" format, i.e. includes the time-zone offset, then you will
have no problem as the data represents a point in time.
It is easier to conceptualize "time stamp with time zone" (timestamptz) as
actually repres
On Wed, Apr 15, 2020 at 7:50 PM Niels Jespersen wrote:
> Hello all
>
>
>
> We have some data that have entered a timestamp column from a csv. The
> data in the csv are in utc. We want to access the data in our native
> timezone (CET).
>
>
>
> I am considering a few alternatives:
>
>
>
> 1.
Hello all
We have some data that have entered a timestamp column from a csv. The data in
the csv are in utc. We want to access the data in our native timezone (CET).
I am considering a few alternatives:
1. Early in the process, convert to timestamptz and keep this datatype.
2. Ear
16 matches
Mail list logo