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

From Michael Schuerig
Subject Re: Setting date format for a single output column?
Date
Msg-id 200509140346.21803.michael@schuerig.de
Whole thread Raw
In response to Re: Setting date format for a single output column?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
On Wednesday 14 September 2005 02:32, Alvaro Herrera wrote:
> 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.

I had considered that, but I received a better suggestion by private
mail:

  Select to_char(date_column, 'dd/mm/yyyy') as date_column

Thanks to all who responded.

Michael

--
Michael Schuerig                       Face reality and stare it down
mailto:michael@schuerig.de        --Jethro Tull, Silver River Turning
http://www.schuerig.de/michael/

pgsql-general by date:

Previous
From: Joe
Date:
Subject: Partial dates
Next
From: "Dann Corbit"
Date:
Subject: Re: MS SQL - PostgreSQL