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