Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3C286807727
	for <pgsql-sql@postgresql.org>; Wed, 11 Apr 2001 22:08:07 -0400 (EDT)
	(envelope-from rmello@fslc.usu.edu)
Received: (from rmello@localhost)
	by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id
	f3C282pB022807
	for pgsql-sql@postgresql.org; Wed, 11 Apr 2001 20:08:02 -0600
Date: Wed, 11 Apr 2001 20:08:02 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: pgsql-sql@postgresql.org
Subject: Timezone conversion
Message-ID: <20010411200802.A22619@cc.usu.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.15i
X-Archive-Number: 200104/171
X-Sequence-Number: 2519

	Hi,

	How can I do timezone conversions in PG? I looked on the docs and
couldn't find how. I want to find the current time in another timezone.

	Thanks,

	-Roberto

P.S: This type of function would be excellent on the cookbook
(www.brasileiro.net).
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Ad astra, per ardua nostra.