From: Richard Huxton <dev@archonet.com>
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: ISO time zone format
Date: Wed, 05 Sep 2007 09:16:34 +0100
Message-ID: <46DE65E2.6090904@archonet.com> (raw)
In-Reply-To: <fbllup$10m8$1@news.hub.org>
References: <fbllup$10m8$1@news.hub.org>
Sabin Coanda wrote:
> Hi there,
>
> I'd like to format a time stamp with time zone as ISO pattern (e.g.
> 1999-01-08 04:05:06 -8:00)
>
> I found the patterns for all the timestamp parts, from "Data Type Formatting
> Functions" Postgresql documentation, excepting the numeric ISO time zone.
>
> Please suggest the appropiate pattern for that.
If your DateStyle is set to ISO that's the default format. You don't
need to use to_char()
Or am I missing your point?
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, sabin.coanda@deuromedia.ro
Subject: Re: ISO time zone format
In-Reply-To: <46DE65E2.6090904@archonet.com>
* 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