fetus Diary

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

INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+0000');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+0200');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+0400');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+0600');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+0800');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+1000');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00+1200');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-0200');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-0400');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-0600');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-0800');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-1000');
INSERT INTO timestamp_test_data VALUES ('2007-01-01 00:00:00-1200');
SELECT * FROM timestamp_test_data ORDER BY time ASC;

[******@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
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
          time
------------------------
 2006-12-31 21:00:00+09
 2006-12-31 23:00:00+09
 2007-01-01 01:00:00+09
 2007-01-01 03:00:00+09
 2007-01-01 05:00:00+09
 2007-01-01 07:00:00+09
 2007-01-01 09:00:00+09
 2007-01-01 11:00:00+09
 2007-01-01 13:00:00+09
 2007-01-01 15:00:00+09
 2007-01-01 17:00:00+09
 2007-01-01 19:00:00+09
 2007-01-01 21:00:00+09
(13 rows)

………time zone は保存してくれないの?