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