In article <20071214.001009.67102034.t-ishii@xxxxxxxxxxxx>,
Tatsuo Ishii <ishii@xxxxxxxxxxxxxx> wrote:
% From: "Magnus Hagander" <magnus@xxxxxxxxxxxx>
[...]
% > > Can I get "+04" without knowing that I inserted the data using "+0400"
% > > time zone?
% > No. The closest you can get is to store the tz in a different column
% and use AT TIMEZONE (which accepts a column name as argument)
% Or use date + time with time zone.
This could cause problems if you want to insert a timestamp for a date
with different DST settings. It also seems a lot more cumbersome to do
it this way.
--
Patrick TJ McPhee
North York Canada
ptjm@xxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
