On Tue, Nov 05, 2002 at 20:03:37 +0000,
TJ <tj@nospam.com> wrote:
>
> I think I need to somehow display these timestamps back into their timezone
> of origin...so as to be more intuitive for the managers.
You can use SET TIME ZONE in a session to change the time zone used for
outputting time. For example:
area=> select current_time;
timetz
--------------------
10:03:02.390849-06
(1 row)
area=> set time zone 'PST8PDT';
SET
area=> select current_time;
timetz
--------------------
08:03:19.241939-08
(1 row)