Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> JDBC OCI and NLS_DATE_FORMAT

JDBC OCI and NLS_DATE_FORMAT

From: chazalet <sylvie.chazalet_at_exane.com>
Date: Fri, 20 Apr 2001 08:47:23 GMT
Message-ID: <3ADFF7A1.EE5A8F55@exane.com> 






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 - 03:47:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US