pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: A. Kretschmer <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: Postgresql format for ISO8601
Date: Wed, 17 Mar 2010 08:13:36 +0100
Message-ID: <20100317071335.GC25571@a-kretschmer.de> (raw)
In-Reply-To: <62e0109f1003162359l65b6961ercd14b687433a9ff3@mail.gmail.com>
References: <62e0109f1003162359l65b6961ercd14b687433a9ff3@mail.gmail.com>
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
view thread (4+ messages) latest in thread
Message-ID: <20100317071335.GC25571@a-kretschmer.de> Permalink: ../20100317071335.GC25571@a-kretschmer.de/ Also on: postgresql.org/message-id/20100317071335.GC25571@a-kretschmer.de ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: andreas.kretschmer@schollglas.com Subject: Re: Postgresql format for ISO8601 In-Reply-To: <20100317071335.GC25571@a-kretschmer.de> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
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