How do I convert a timestamp with time zone to local time?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How do I convert a timestamp with time zone to local time?
Date: 2008-07-29 18:07:46
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D9A2170@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings!

What is the best way to convert a time expressed as a timestamp with
time zone into a timestamp in the local time zone without knowing what
the local time zone is?

Thank you.

RobR

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Valter Douglas Lisbôa Jr. 2008-07-29 18:36:23 Re: How do I convert a timestamp with time zone to local time?
Previous Message Francisco Reyes 2008-07-29 18:06:53 Index creation and maintenance_work_mem