Re: JDBC OCI and NLS_DATE_FORMAT

I guess the alter session does not work because it is dynamic SQL, not a query. If you have a method for executing PL/SQL procedures you could try

dbms_utility.exec_ddl_statement ('alter session set nls_date_format = ''dd/mm/yyyy''')

Martin

chazalet wrote:
>
> Hi,
>
> Configuration : Oracle Client 8.1.6 -Solaris 2.7
> JDBC OCI.
> stmt.executeQuery("alter session set NLS_DATE_FORMAT='DD/MM/YYYY'")
> doesn't work.
> The date format by default with JDBC OCI is :
> YYYY-MM-DD HH:MM:SS.0
> I don't want to use the function TO_CHAR on every date columns.
> ??????
>
> Thanks in advance
>
> Sylvie
Received on Fri Apr 20 2001 - 11:13:26 CDT