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.