Re: [SQL] external environment variable

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é