date problem in oracle 10g

5 pts.
Tags:
Oracle 10g
in my oracle 10g server, date is changing by it self some time like in this manner "28-Feb-2008" to "20-Feb-0028". and it will keep interchanging until we restart the server. any budy is having any solution
ASKED: March 13, 2008  4:13 PM
UPDATED: August 26, 2010  7:36 PM

Answer Wiki

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

check for a login.sql in your ORACLE_HOME directory. Sounds like something is changing your date_format for the session.

Discuss This Question: 1  Reply

 
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
  • Kccrosser
    Check your NLS_LANG and NLS PARAMETERS settings. You don't specify your host platform (Unix, Windows, ?) and NLS_LANG is set outside the database. Check your documentation on how to see/set the NLS_LANG setting. If this isn't set right for your country/language/style, this will aftect other items. To check your local parameters, use:
    select * from NLS_SESSION_PARAMETERS
    See what your NLS_DATE_FORMAT value is - it sounds like someone is setting it to "YYMMM00DD" You can set it back with:
    ALTER SESSION SET NLS_DATE_FORMAT="DD-MON-YYYY"
    As noted, you may have a login.sql file that is mangling the format, or some script/procedure you are running may have an ALTER SESSION in it.
    3,830 pointsBadges:
    report

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