Localization (for dates) Oracle vs. Postgresql

From: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <'pgsql-general(at)postgresql(dot)org'>
Subject: Localization (for dates) Oracle vs. Postgresql
Date: 2003-09-03 09:06:34
Message-ID: 70DD6153277512439CA4B66956A3098132D07B@pdc.4tek-net.4tek.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am a Postgres newbie who worked until now with Oracle.
Now I want to know if it is possible (when yes the how?) in Postgresql
To set dynamically the Localization?
For example in Oracle you can set the Localization for dates like this
Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America

This example would set the Date-Localization to American but only for the actual session.

Is something like this possible in Postgresql???

Thanxx

Schoeib Amin

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel. +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-09-03 09:09:01 Re: Querying $libdir
Previous Message Amin Schoeib 2003-09-03 09:00:09 Oracle decode Function in Postgres