[SQL] Postgresql format for ISO8601

. Thanks, Arnab Ghosh On Wed, Mar 17, 2010 at 12:43 PM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > > In response to Arnab Ghosh : > > Hello Friends, > > > > I want to format a timstamp with timezone column with ISO 8601 FORMAT ([]- > > [MM]-[DD]T[h

[SQL] Postgresql format for ISO8601

Hello Friends, I want to format a timstamp with timezone column with ISO 8601 FORMAT ( []-[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