Postgres Pro
Downloads
Home   >   mailing lists

Re: timezone_hour missing - Mailing list pgsql-general

From Kari Lempiainen
Subject Re: timezone_hour missing
Date
Msg-id cics5v8itv2itsf079docrca7vgql41skj@4ax.com
Whole thread Raw
In response to timezone_hour missing  (Kari Lempiainen <kari@funky.pp.fi>)
List pgsql-general
Tree view 
Oleg Samoylov <olleg@telecom.mipt.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

pgsql-general by date:

Previous
From: DangVan Chinh
Date:
Subject: Help me!
Next
From: Raphael Bauduin
Date:
Subject: Re: pg and chroot (performance)