Re: Setting date format for a single output column? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Setting date format for a single output column?
Date
Msg-id 20050914003230.GA347@surnet.cl
Whole thread Raw
In response to Setting date format for a single output column?  (Michael Schuerig <michael@schuerig.de>)
Responses Re: Setting date format for a single output column?
List pgsql-general
On Wed, Sep 14, 2005 at 02:12:34AM +0200, Michael Schuerig wrote:
>
> I'd like to get date columns in the results of a query in the
> appropriate format (EUROPEAN, GERMAN). I've tried to set DATESTYLE and
> it works as far as PgSQL is concerned. Unfortunately, though, this
> confuses the date parsing of the O/R-Mapper I'm using[*]. Is there a way
> to set the date style/format on a per column basis for the result
> returned by a SELECT statement?

You could SET datestyle just before issuing the query (so it's not a
per-column answer, but per-query), or use the to_char() function instead
of using the default output.

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)

pgsql-general by date:

Previous
From: Michael Schuerig
Date:
Subject: Setting date format for a single output column?
Next
From: Matthew Terenzio
Date:
Subject: Re: Question about PHP and PostgreSQL