Re: timestamp with time zone

In article <20071214(dot)001009(dot)67102034(dot)t-ishii(at)sraoss(dot)co(dot)jp>,
Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
% From: "Magnus Hagander" <magnus(at)hagander(dot)net>

[...]

% > > 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(at)interlog(dot)com