Skip site navigation (1) Skip section navigation (2)

problems with datestyle

From: João Paulo F(dot) Diniz <jpaulo(at)dcc(dot)ufmg(dot)br>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: problems with datestyle
Date: 2004-04-01 21:15:50
Message-ID: Pine.GSO.4.58.0404011728380.2351@ciclope (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I'm using a java program to connect to a postgresql database (I'm using
postgresql version 7.2.1).
I'd like to retrieve a value of type DATE with ResultSet.getString()
method
in the format dd/mm/yyyy without make any more changes in the program.

I've already tried to Change PGDATESTYLE to "sql, european".
When I access database on the console whith postgres user all dates are
showed in format dd/mm/yyyy, but it doesn't with a java program.

How can I use postmaster whith options -o -e?

OR

How can I change datastyle in postgresql.conf?


Thanks in advance!

Responses

pgsql-jdbc by date

Next:From: Sean ShannyDate: 2004-04-01 21:21:54
Subject: Re: disabling seq scans
Previous:From: Marcus Andree S. MagalhaesDate: 2004-04-01 21:12:08
Subject: Re: disabling seq scans

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group