Why do I get different date/time after explicitly setting timezone?
This is RH Linux 5.2.
test=> select '1998-09-23 12:05:10 HST'::datetime;
?column?
------------------------------
Thu Sep 24 07:05:10 1998 JST
(1 row)
test=> show timezone;
NOTICE: Time zone is unknown
SHOW VARIABLE
test=> set timezone to 'JST';
SET VARIABLE
test=> select '1998-09-23 12:05:10 HST'::datetime;
?column?
------------------------------
Wed Sep 23 22:05:10 1998 JST
(1 row)
--
Tatsuo Ishii