Skip site navigation (1) Skip section navigation (2)

Inserting timestamp values

From: "cnliou" <cnliou(at)so-net(dot)net(dot)tw>
To: "" <pgsql-docs(at)postgresql(dot)org>
Subject: Inserting timestamp values
Date: 2003-12-02 16:24:03
Message-ID: 1070382243.61976.cnliou@so-net.net.tw (view raw or flat)
Thread:
Lists: pgsql-docs
Hi!

Does my test result comply with the statements in section 
"8.5 Date/Time Types"? My shell set local time to UTC+8 
hours. I was in the impression that the query

insert into test values ('2003-2-1'::timestamp);

equals to

insert into test values ('2003-2-1'::timestamp without time 
zone);

but my test results seem to show the other way.

db1=# show time zone;
 TimeZone 
----------
 unknown
(1 row)

db1=# \d test
              Table "public.test"
 Column |           Type           | Modifiers 
--------+--------------------------+-----------
 f1     | timestamp with time zone | 

db1=# insert into test values ('2003-1-1'::timestamp);
INSERT 46230 1
db1=# select * from test;
           f1           
------------------------
 2003-01-01 00:00:00+08
(1 row)

db1=# set time zone 9;
SET
db1=# insert into test values ('2003-2-1'::timestamp);
INSERT 46231 1
db1=# select * from test;
           f1           
------------------------
 2003-01-01 01:00:00+09
 2003-02-01 00:00:00+09
(2 rows)

db1=# set time zone 0;
SET
db1=# select * from test;
           f1           
------------------------
 2002-12-31 16:00:00+00
 2003-01-31 15:00:00+00
(2 rows)

Regards,

CN

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2003-12-02 16:40:57
Subject: Re: Inserting timestamp values
Previous:From: Tom LaneDate: 2003-12-02 00:27:36
Subject: Re: [PATCHES] Numeric version of factorial()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group