Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 2B3D27983A0
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 17 Mar 2010 04:05:40 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 49883-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 17 Mar 2010 07:05:29 +0000 (UTC)
X-Greylist: delayed 00:05:43.283936 by SQLgrey-1.7.6
Received: from mail-iw0-f180.google.com (mail-iw0-f180.google.com
	[209.85.223.180])
	by mail.postgresql.org (Postfix) with ESMTP id 5F612797B1E
	for <pgsql-sql@postgresql.org>; Wed, 17 Mar 2010 04:05:29 -0300 (ADT)
Received: by iwn10 with SMTP id 10so695380iwn.28
	for <pgsql-sql@postgresql.org>; Wed, 17 Mar 2010 00:05:28 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.231.191.131 with SMTP id dm3mr1528537ibb.45.1268809184070;
	Tue, 16 Mar 2010 23:59:44 -0700 (PDT)
From: Arnab Ghosh <ghosh@glenwoodsystems.com>
Date: Wed, 17 Mar 2010 12:29:24 +0530
Message-ID: <62e0109f1003162359l65b6961ercd14b687433a9ff3@mail.gmail.com>
Subject: Postgresql format for ISO8601
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0016367d6ce8b44bf80481f9a826
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/121
X-Sequence-Number: 33828

--0016367d6ce8b44bf80481f9a826
Content-Type: text/plain; charset=ISO-8859-1

Hello Friends,

I want to format a timstamp with timezone column with ISO 8601 FORMAT (
[YYYY]-[MM]-[DD]T[hh]:[mm]Z)

Please let me know how to format?? I had tried with to_char but unable to
format to ISO-8601 format.

Thanks,
Arnab Ghosh

--0016367d6ce8b44bf80481f9a826
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello Friends,<br><br>I want to format a timstamp with timezone column with=
 ISO 8601 FORMAT (<span style=3D"white-space: nowrap;">[YYYY]-[MM]-[DD]T[hh=
]:[mm]Z</span>)<br><br>Please let me know how to format?? I had tried with =
to_char but unable to format to ISO-8601 format.<br>

<br>Thanks,<br>Arnab Ghosh<br>

--0016367d6ce8b44bf80481f9a826--