pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql format for ISO8601
4+ messages / 3 participants
[nested] [flat]
* Postgresql format for ISO8601
@ 2010-03-17 06:59 Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 07:13 ` Re: Postgresql format for ISO8601 A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 4+ messages in thread
From: Arnab Ghosh @ 2010-03-17 06:59 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql format for ISO8601
2010-03-17 06:59 Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
@ 2010-03-17 07:13 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2010-03-17 12:25 ` Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
0 siblings, 1 reply; 4+ messages in thread
From: A. Kretschmer @ 2010-03-17 07:13 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Postgresql format for ISO8601
2010-03-17 06:59 Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 07:13 ` Re: Postgresql format for ISO8601 A. Kretschmer <andreas.kretschmer@schollglas.com>
@ 2010-03-17 12:25 ` Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 14:10 ` Re: Postgresql format for ISO8601 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Arnab Ghosh @ 2010-03-17 12:25 UTC (permalink / raw)
To: 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.kretschmer@schollglas.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql format for ISO8601
2010-03-17 06:59 Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 07:13 ` Re: Postgresql format for ISO8601 A. Kretschmer <andreas.kretschmer@schollglas.com>
2010-03-17 12:25 ` Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
@ 2010-03-17 14:10 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-03-17 14:10 UTC (permalink / raw)
To: Arnab Ghosh <ghosh@glenwoodsystems.com>; +Cc: pgsql-sql
Arnab Ghosh <ghosh@glenwoodsystems.com> 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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-03-17 14:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-17 06:59 Postgresql format for ISO8601 Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 07:13 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2010-03-17 12:25 ` Arnab Ghosh <ghosh@glenwoodsystems.com>
2010-03-17 14:10 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox