Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group