Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle NLS_DATE_FORMAT for JDBC

 
Adam Hardy
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic