change in sysdate

[premkumarsp1]

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]

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

[amitpatel66]

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.

[premkumarsp1]

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