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(at)sss(dot)pgh(dot)pa(dot)us]
Gesendet: Mittwoch, 3. September 2003 16:21
An: Amin Schoeib
Cc: pgsql-general(at)postgresql(dot)org
Betreff: Re: AW: [GENERAL] Localization (for dates) Oracle vs. Postgresql

"Amin Schoeib" <aschoeib(at)4tek(dot)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 such localization in the basic date or timestamp datatypes, though.

regards, tom lane