Re: ISO time zone format

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ISO time zone format
Date: 2007-09-05 13:09:15
Message-ID: fbm9pi$1hvu$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-09-05 14:32:53 Re: ISO time zone format
Previous Message roy simkes 2007-09-05 08:33:26 tsearch2 query question