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:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. September 2003 16:21 An: Amin Schoeib Cc: [EMAIL PROTECTED] Betreff: Re: AW: [GENERAL] Localization (for dates) Oracle vs. Postgresql "Amin Schoeib" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend