Re: ISO time zone format

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