Postgres Pro
Downloads
Home   >   mailing lists

ISO time zone format - Mailing list pgsql-sql

From Sabin Coanda
Subject ISO time zone format
Date
Msg-id fbllup$10m8$1@news.hub.org
Whole thread Raw
Responses Re: ISO time zone format
Re: ISO time zone format
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: work hour calculations
Next
From: Aleksandr Vinokurov
Date:
Subject: Re: 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution