Postgres Pro
Downloads
Home   >   mailing lists

Re: ISO time zone format - Mailing list pgsql-sql

From Sabin Coanda
Subject Re: ISO time zone format
Date
Msg-id fbmfv1$gg6$1@news.hub.org
Whole thread Raw
In response to ISO time zone format  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
Tree view 
>
> 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

pgsql-sql by date:

Previous
From: "Joel Fradkin"
Date:
Subject: recursive query
Next
From: "hu js"
Date:
Subject: How to use serial variable to insert into muiti-recrods?