ISO time zone format

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: ISO time zone format
Date: 2007-09-05 07:30:41
Message-ID: fbllup$10m8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

TIA,
Sabin

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aleksandr Vinokurov 2007-09-05 07:57:13 Re: 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution
Previous Message A. Kretschmer 2007-09-05 06:45:27 Re: work hour calculations