Re: Localization (for dates) Oracle vs. Postgresql

First of all I want to thank you for your quick response.

That would be very nice if it is possible.
But using to_char I can only set the format or is it in Postgres
Other?
When I would execute this:
select to_char(now(),'DD.Month,YYYY')
I would get the monthname in english but how can I perform with to_char
That I become the monthname in german??

-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Gesendet: Mittwoch, 3. September 2003 16:21
An: Amin Schoeib
Cc: pgsql-general@postgresql.org
Betreff: Re: AW: [GENERAL] Localization (for dates) Oracle vs. Postgresql


"Amin Schoeib" <aschoeib@4tek.de> writes:
> I want to change for example for one session the date-format from
> english to german, so that The month names for example march will be
> März in German. I only need that for the monthnames.

I think you can do this if you are willing to use to_char() to format the dates for display.  There's no provision for
suchlocalization in the basic date or timestamp datatypes, though. 

            regards, tom lane