Re: Timezone conversion

From: Grant <grant(at)conprojan(dot)com(dot)au>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timezone conversion
Date: 2001-04-19 00:32:31
Message-ID: Pine.LNX.4.21.0104191031580.7965-100000@webster.conprojan.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Convert it to timestamp and minus TIMEZONE * 3600...

On Wed, 11 Apr 2001, Roberto Mello wrote:

> 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).
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Martín Marqués 2001-04-19 05:24:00 Re: groups in postgres
Previous Message Michael Fork 2001-04-18 21:47:43 RE: Re: DB porting questions...