Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA02987 for ; Wed, 14 Apr 1999 09:42:56 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id PAA14873; Wed, 14 Apr 1999 15:42:30 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10XRoF-0007yn-00; Wed, 14 Apr 1999 15:42:39 +0000 Message-ID: <37149AD1.B1234DBB@sferacarta.com> Date: Wed, 14 Apr 1999 15:40:33 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Randal Flagg CC: pgsql-sql@postgresql.org Subject: Re: [SQL] external environment variable References: <19990414100246.311.qmail@hotmail.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Randal Flagg ha scritto: > Hi!!, > I've a little problem. I've installed Apache JServ 1.03b and it > works very good, I've also installed PostreSQL 6.4 and I set the > environment variable PGDATESTYLE in the /etc/profile file. When I use > PostgreSQL directly, date's fields are shown according to the > PGDATESTYLE but, when I query a table across the Web using a Servlet > PostreSQL ignore PGDATESTYLE and use it's default. > use command set Description: set run-time environment Syntax: SET DateStyle TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean' example: set datestyle to 'ISO'; José