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


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