Re: [SQL] Postgresql format for ISO8601

2010-03-17 Thread Tom Lane
Arnab Ghosh writes: > ISO 8601 Timezone Example - > 1994-11-05T08:15:30-05:00 corresponds to November 5, 1994, 8:15:30 am, US > Eastern Standard Time. AIUI, the T is optional per spec and therefore PG's default timestamp output format already meets the 8601 standard. reg

Re: [SQL] Postgresql format for ISO8601

2010-03-17 Thread A. Kretschmer
In response to Arnab Ghosh : > 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. Don't know much about ISO 8601, but