change in sysdate

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • premkumarsp1
    New Member
    • Feb 2008
    • 12

    change in sysdate

    hi
    in the oracle sysdate, time is coming wrongly. THe date and time in the OS from where i am accessing oracle and in the OS where oracle is installed is correct. I want to know how to update time in sysdate. can someone help me with this problem.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    if date and time is correct in the server then how it can be wrong.

    Comment

    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358

      #3
      Dear, From the term SYSDATE, it says clearly that its a SYSTEM DATE. Do a small test by changing your OS date in which the oracle DB is installed and check if that affects your SYSDATE value.

      Comment

      • premkumarsp1
        New Member
        • Feb 2008
        • 12

        #4
        Hi all
        thanks ....my sysdate is wrong ....once i corrected it...now its fine........

        Comment

        Working...