Re: Inserting timestamp values

Tom Lane kirjutas T, 02.12.2003 kell 18:40:
> "cnliou" <cnliou@so-net.net.tw> writes:
> > Does my test result comply with the statements in section
> > "8.5 Date/Time Types"?
>
> I think so.  You are inserting into a timestamp-with-time-zone column,
> so even though you mark the literal constant as timestamp without time
> zone, it's going to be converted to timestamp with time zone.

Maybe he is wondering about it getting converted to +8 time zone even
when the time zone is 'unknown' :

> 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