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

From Sabin Coanda
Subject Re: ISO time zone format
Date
Msg-id fbm9pi$1hvu$1@news.hub.org
Whole thread Raw
In response to ISO time zone format  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Responses Re: ISO time zone format
List pgsql-sql
>
> 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?
>

Hi Richard,

I'd just like to format it independent of my DateStyle. Some timestamp parts 
may be formatted this way.

For instance I can format ISO date with to_char( dt, 'YYYY-MM-DD'), and ISO 
time with to_char( dt, 'HH24:MI:SS') as well. I'd just like to find the 
format pattern for the ISO time zone (numeric).

Regards,
Sabin





pgsql-sql by date:

Previous
From: roy simkes
Date:
Subject: tsearch2 query question
Next
From: Richard Huxton
Date:
Subject: Re: ISO time zone format