From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: ISO time zone format
Date: Wed, 5 Sep 2007 10:58:17 +0300
User-Agent: KMail/1.9.3
References: <fbllup$10m8$1@news.hub.org>
In-Reply-To: <fbllup$10m8$1@news.hub.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200709051058.18158.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 =CE=A4=CE=B5=CF=84=CE=AC=CF=81=CF=84=CE=B7 05 =CE=
=A3=CE=B5=CF=80=CF=84=CE=AD=CE=BC=CE=B2=CF=81=CE=B9=CE=BF=CF=82 2007 10:30,=
 =CE=BF/=CE=B7 Sabin Coanda =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hi there,
>
> I'd like to format a time stamp with time zone as ISO pattern (e.g.
> 1999-01-08 04:05:06 -8:00)
>
> I found the patterns for all the timestamp parts, from "Data Type
> Formatting Functions" Postgresql documentation, excepting the numeric ISO
> time zone.
>
> Please suggest the appropiate pattern for that.

Have you tried the default PgSQL behaviour, without setting DateStyle, or=20
doing any explicit formating?
Maybe its exactly what you want.
What does=20
select now();
from within psql, output in your system?
>
> TIA,
> Sabin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

=2D-=20
Achilleas Mantzios