Thread: europeans dates whith jdbc
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, -- Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11 http://jmreymond.free.fr/Etna2002
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
Kris Jurka wrote: >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 > > > > > works fine now with your solution. thanks a lot, -- Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11 http://jmreymond.free.fr/Etna2002