From: | Arnab Ghosh <ghosh(at)glenwoodsystems(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Postgresql format for ISO8601 |
Date: | 2010-03-17 12:25:14 |
Message-ID: | 62e0109f1003170525m6e187b32n58850bd48259daa8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello Friends,
I have tried with to_char. But unable to find out how to show offset of
difference in timezone.
ISO 8601 Timezone Example -
1994-11-05T08:15:30-05:00 corresponds to November 5, 1994, 8:15:30 am, US
Eastern Standard Time.
1994-11-05T13:15:30Z corresponds to the same instant.
Thanks,
Arnab Ghosh
On Wed, Mar 17, 2010 at 12:43 PM, A. Kretschmer <
andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
>
> 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
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2010-03-17 12:28:44 | Re: pgAgent stats |
Previous Message | Marcin Krawczyk | 2010-03-17 12:24:17 | Re: pgAgent stats |