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

Home -> Community -> Usenet -> c.d.o.misc -> How to change default date format for my application

How to change default date format for my application

From: Axel Seinsche <newsgroup_at_seinsche.net>
Date: Sun, 26 Sep 2004 16:16:57 +0200
Message-ID: <4156cec2$0$25785$9b622d9e@news.freenet.de> 





Hi all,



I am using Oracle DB's from 8.1.7 to 10.1 and have a general problem. 
How can I set the default date format so that the time part will be 
displayed to in my Java application or my JSP pages.



I already tried to set the NLS_DATE_FORMAT env variable, but with this 
the fields are only displayed correctly in sqlplus, but not in my SQL 
client or my JSP pages. I hope someone has a hint for me.



TIA,



Axel
Received on Sun Sep 26 2004 - 09:16:57 CDT












Original text of this message













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