On Tuesday 29 July 2008 15:07:46 Rob Richardson wrote: > 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 SELECT extract (epoch from your_time_field) from your_table; SELECT to_timestamp(your_epoch_field) from your_table;
-- Valter Douglas Lisbôa Jr. Sócio-Diretor Trenix - IT Solutions "Nossas Idéias, suas Soluções!" www.trenix.com.br [EMAIL PROTECTED] Tel. +55 19 3402.2957 Cel. +55 19 9183.4244 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general