Date conversion (to_char) behavior

70220 pts.
Tags:
Microsoft Windows
Oracle
SQL
Hi everybody. 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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

In case someone else finds a similar situation, the problem was that the Oracle client software was installed in Spanish.

Some of the options to fix it were:

-create a logon trigger to change the nls session parameters if needed
-modify the machine’s registry
-reinstall Oracle client software

We opted by the third one.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following