Re: timestamps cannot be created without time zones - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: timestamps cannot be created without time zones
Date
Msg-id Pine.LNX.4.30.0108241744180.677-100000@peter.localdomain
Whole thread Raw
In response to Re: timestamps cannot be created without time zones  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: timestamps cannot be created without time zones  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Bruce Momjian writes:

> Let me see if I follow here.  If I am in the Eastern timezone and enter
> a time for 9pm, 1/1/1850, and someone else in the Central timezone
> enters the same time, if I look at the two dates from the Eastern
> timezone I will see mine as 9pm and the other as 10pm?

That's exactly what happens, only that the central time would probably
show 8pm.

> Wow, I wonder if that is bad?

Depends on the application.  I do wonder how the backend gets to know the
time zone from the front end.  export PGTZ seems to do that, but not
export TZ, which is the standard variable.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bug #424: JDBC driver security issue.
Next
From: Tomasz Zielonka
Date:
Subject: Re: Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions