IntelliJ Java IDE
The moose likes JDBC and the fly likes Oracle NLS_DATE_FORMAT for JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "Oracle NLS_DATE_FORMAT for JDBC" Watch "Oracle NLS_DATE_FORMAT for JDBC" New topic
Author

Oracle NLS_DATE_FORMAT for JDBC

Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 563
Hi,
I'm trying to set the NLS_DATE_FORMAT to influence my application server's JDBC connection to an Oracle database and I can't manage it.
I'm using NT with Tomcat and I've set NLS_DATE_FORMAT in the command line when I start tomcat and in my environment settings where my classpath and ora81\bin path is defined, but it's not taking it.
It defaults to something else and won't allow me to enter dates as strings. I could use TO_DATE("xxxx") I know but I would like to control it with NLS_DATE_FORMAT.
Thanks for any help.
Regards
Adam


I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
 
IntelliJ Java IDE
 
subject: Oracle NLS_DATE_FORMAT for JDBC
 
Threads others viewed
EJBQL with dates / CMP BLOB Problem
Lot of open Oracle statements
url for datasource (urgent)
Reading date from Oracle based on calendar
while connecting with "system" occures ORA-01821 error
MyEclipse, The Clear Choice