Re: [HACKERS] timezone problem? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] timezone problem?
Date
Msg-id 25130.948408159@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] timezone problem?  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Responses Re: [HACKERS] timezone problem?
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> HST is interpreted by Postgres as Hawaii Standard Time, which is on
> the other side of the date line from Japan. Planning a vacation
> Tatsuo?? :))

Then there's still something wrong:

> test=> select '1998-09-23 12:05:10 HST'::datetime;
> ------------------------------
>  Wed Sep 23 22:05:10 1998 JST

10 hours behind JST (= GMT+9, IIRC) is in the wrong ocean to be
Hawaii...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] COPY problems with psql / libpq
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] off topic