Re: ISO time zone format - Mailing list pgsql-sql

From Richard Huxton
Subject Re: ISO time zone format
Date
Msg-id 46DE65E2.6090904@archonet.com
Whole thread Raw
In response to ISO time zone format  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: ISO time zone format
Next
From: "Marc Mamin"
Date:
Subject: Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?