Re: Localization Oracle vs. Postgresql

From: Terry Yapt <pgsql(at)technovell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Localization Oracle vs. Postgresql
Date: 2003-08-29 16:34:32
Message-ID: 220vkvcuvbsvu93fbbjfgikhoo4hdrll7v@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>For example in Oracle you can set the Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America

SET DATESTYLE TO NonEuropean;

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

This one too I think so.

>Is something like this possible in Postgresql???

Look at:
http://www.postgresql.org/docs/7.3/static/sql-set.html

Greetings

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-29 16:40:42 Re: Database Replication
Previous Message Andrew Sullivan 2003-08-29 16:32:39 Re: Postgresql for Solaris on Sparc