Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
> (

In response to


pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group