Postgresql format for ISO8601

From: Arnab Ghosh <ghosh(at)glenwoodsystems(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Postgresql format for ISO8601
Date: 2010-03-17 06:59:24
Message-ID: 62e0109f1003162359l65b6961ercd14b687433a9ff3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2010-03-17 07:13:36 Re: Postgresql format for ISO8601
Previous Message Jorge Godoy 2010-03-16 23:42:31 Re: installing uuid generators