fetus Diary
twitter: @fetus_hina / Twilog
ポプともID: 4174-5004-0070 (チャレ/最高38/安定34)
IIDX ID: 3604-3873 (SP六段底辺)
2007/10/05(金) - timestamp with time zone
[******@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 は保存してくれないの?
コメント
コメントはありません。