Re: ISO time zone format

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ISO time zone format
Date: 2007-09-05 14:54:24
Message-ID: fbmfv1$gg6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> For the moment, you'll have to use extract() to pick out the bit(s) you
> need:
> to_char(extract(timezone_hour from current_timestamp), 'S00');
>

It's perfect for me, thanks a lot.
Sabin

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message hu js 2007-09-06 07:11:18 How to use serial variable to insert into muiti-recrods?
Previous Message Joel Fradkin 2007-09-05 14:47:29 recursive query