Re: europeans dates whith jdbc

On Mon, 15 Dec 2003, Jean-Max Reymond wrote:

> iI have a 7.4 base created by createdb -E LATIN9 mybase and datestyle =
> 'Postgres, European' in the postgresql.conf config file. all is fine
> with psql and my dates are displayed correctly.
> But, with JDBC, I am unable to have the date in European format. there
> are all in ISO format (YYYY-MM-DD).
> does it exist a parameter to set?
> thanks for yours answers,

I assume you are using getString() to retrieve the column in question?  In
Java a more appropriate method would be to use getDate() and use the jvm's
locale settings to format it or SimpleDateFormat if that suits you better.

It is significantly easier for the JDBC driver to set and use its own
datestyle rather than having each date related call be conditional on the
current datestyle settings.

Kris Jurka