Re: timezone_hour missing

From: Kari Lempiainen <kari(at)funky(dot)pp(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: timezone_hour missing
Date: 2003-02-27 15:44:37
Message-ID: cics5v8itv2itsf079docrca7vgql41skj@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Samoylov <olleg(at)telecom(dot)mipt(dot)ru> wrote:

>Try:
>
>template1=# select extract(timezone_hour from timestamp with time zone
>'2001-10-10 01:04:54.965162+03');
> date_part
>-----------
> -4
>(1 row)

Did tre trick. Thanks!!

Kari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Bucanac 2003-02-27 15:52:03 Prepared queries in 7.2.x? and stmt caching
Previous Message Marc G. Fournier 2003-02-27 15:43:29 Re: Help! I don't get mail anymore