Convert it to timestamp and minus TIMEZONE * 3600...
On Wed, 11 Apr 2001, Roberto Mello wrote:
> 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.
> P.S: This type of function would be excellent on the cookbook
In response to
pgsql-sql by date
|Next:||From: Martín Marqués||Date: 2001-04-19 05:24:00|
|Subject: Re: groups in postgres|
|Previous:||From: Michael Fork||Date: 2001-04-18 21:47:43|
|Subject: RE: Re: DB porting questions...|