Timezone conversion

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Timezone conversion
Date: 2001-04-12 02:08:02
Message-ID: 20010411200802.A22619@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Lonnie Cumberland 2001-04-12 04:16:17 Calling plSQL functions
Previous Message Joel Burton 2001-04-11 23:34:11 Re: DB porting questions...