alter session set nls_date_format do not set what is given.
Hi it is for DB 19C, and java 1.8.0_x application, do not set nls_data_format with result set
System.out.println(s.execute("alter session set nls_date_format='mm/dd/yyyy'"));
s = conn.createStatement();
s.execute("alter session set nls_date_format='mm/dd/yyyy'");
Result set prints with List, shows date as mm-dd-yyyy and not mm/dd/yyyy.
user is using dbms8.jar
Please let us know if what is issue and remediation and if need more details.
Thank you
Rajive