Re: ISO time zone format

From: Richard Huxton <dev(at)archonet(dot)com>
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ISO time zone format
Date: 2007-09-05 08:16:34
Message-ID: 46DE65E2.6090904@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc Mamin 2007-09-05 08:22:09 Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?
Previous Message Achilleas Mantzios 2007-09-05 07:58:17 Re: ISO time zone format