Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dateformat with JDBC..please help!!

843854Dec 9 2003 — edited Dec 9 2003

Hi,

please..how to get a formated date from Oracle without using to_char() in the query??

I try to set the nls session variables such like NLS_DATE_FORMAT but it doesent work??

ResultSet rs = conn.createStatement();
st.executeQuery("ALTER SESSION SET NLS_DATE_FORMAT = ''YYYY-MM-DD");

regards

Andreas

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2004

Added on Dec 9 2003

#java-database-connectivity-jdbc

6 comments

361 views