On Tuesday 29 July 2008 15:07:46 Rob Richardson wrote:
> 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.
SELECT extract (epoch from your_time_field) from your_table;
SELECT to_timestamp(your_epoch_field) from your_table;
Valter Douglas Lisbôa Jr.
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
Tel. +55 19 3402.2957
Cel. +55 19 9183.4244
In response to
pgsql-general by date
|Next:||From: Alan Hodgson||Date: 2008-07-29 18:53:26|
|Subject: Re: Index creation and maintenance_work_mem|
|Previous:||From: Rob Richardson||Date: 2008-07-29 18:07:46|
|Subject: How do I convert a timestamp with time zone to local time?|