We are experiencing a strange behavior with a "to_char" conversion:
We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with "to_char(given_date,'D')". This returns a 1 for sunday, and 7 for saturday, but there is one machine in which the application gets a 1 for Monday, and 7 for sunday. I know some NLS parameters may affect these conversions, but I thought these parameters needed to be set at database level, not at client level. We tested the same application on 5 more machines connecting to the same database and they work Ok. One difference between them is that the "problem" machine is runnig Win Xp (spanish version) and the others are runnig Win Xp (english version).
Can somebody give me a light ? There is some parameter on the client side which can change this behavior ? Do I need to re-format the machine with English version of win xp ?
I really appreciate your help.