Re: database design with timestamp - Mailing list pgsql-general

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)