fetus Diary

都市指定のタイムゾーン設定が出来ると言うことは…

[******@minokasago ~]$ cat test.sql
CREATE TABLE timestamp_test_data (
    time    timestamp(0) with time zone
);

INSERT INTO timestamp_test_data VALUES ('2007/10/28 00:58:00+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 00:58:30+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 00:59:00+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 00:59:30+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 01:00:00+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 01:00:30+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 01:01:00+0000');
INSERT INTO timestamp_test_data VALUES ('2007/10/28 01:01:30+0000');

SET TIME ZONE 'GMT';
SELECT * FROM timestamp_test_data ORDER BY time ASC;

SET TIME ZONE 'Asia/Tokyo';
SELECT * FROM timestamp_test_data ORDER BY time ASC;

SET TIME ZONE 'Europe/Amsterdam';
SELECT * FROM timestamp_test_data ORDER BY time ASC;

DROP TABLE timestamp_test_data;

[******@minokasago ~]$ psql -h amefurashi -p 5433 -U hoge -f test.sql hoge
Password for user hoge:
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
SET
          time
------------------------
 2007-10-28 00:58:00+00
 2007-10-28 00:58:30+00
 2007-10-28 00:59:00+00
 2007-10-28 00:59:30+00
 2007-10-28 01:00:00+00
 2007-10-28 01:00:30+00
 2007-10-28 01:01:00+00
 2007-10-28 01:01:30+00
(8 rows)

SET
          time
------------------------
 2007-10-28 09:58:00+09
 2007-10-28 09:58:30+09
 2007-10-28 09:59:00+09
 2007-10-28 09:59:30+09
 2007-10-28 10:00:00+09
 2007-10-28 10:00:30+09
 2007-10-28 10:01:00+09
 2007-10-28 10:01:30+09
(8 rows)

SET
          time
------------------------
 2007-10-28 02:58:00+02
 2007-10-28 02:58:30+02
 2007-10-28 02:59:00+02
 2007-10-28 02:59:30+02
 2007-10-28 02:00:00+01
 2007-10-28 02:00:30+01
 2007-10-28 02:01:00+01
 2007-10-28 02:01:30+01
(8 rows)

DROP TABLE

うん、やっぱりちゃんとなった。