Re: Postgresql format for ISO8601

In response to Arnab Ghosh :
> 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.

Don't know much about ISO 8601, but i thing, to_char() should be the
solution. For instance:

test=# select to_char(now(), 'YYYY-MM-DDThh:mm TZ');      to_char
----------------------2010-03-17T08:03 CET

If this isn't correct, please show an example for the correct format,
okay?


Regards, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99