By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,318 Members | 2,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,318 IT Pros & Developers. It's quick & easy.

change in sysdate

P: 12
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.
Mar 16 '08 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
if date and time is correct in the server then how it can be wrong.
Mar 17 '08 #2

amitpatel66
Expert 100+
P: 2,367
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.
Mar 17 '08 #3

P: 12
Hi all
thanks ....my sysdate is wrong ....once i corrected it...now its fine........
Apr 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.