-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Hello,
There is a chance that from where you are invoking sqlplus is having OS date different to that of the date set in the Unix machine where database actually resides.
Eg : There are 2 Unix machines A & B
B is where database(ABCD) resides..
A is where you invoke SQL+ as
sqlplus @ABCD.WORLD
In A it is set as '5 feb 2003'
In B it is set as '10 Feb 2003'.
Then when u give select sysdate from dual;Output would be '10 Feb2003'
But when you give
Sql>!date
5 feb 2003.
Confirm from select host_name from v$instance;
I don't know if I am throwing light or blowing light.
Jus' thinking from a different angle.that's all..
With lots of fun,
Chithra
K.Chithra
Oracle DBA
-
Originally posted by stmontgo
hilarity ensues as a one post reply answer gets exploded to 3 pages of wasted space
Make that 4 pages of wasted space...
Jeff Hunter
-
Originally Posted by sandycrab
Dear Mr. Pando...I hope you got my problem...already my Oracle sysdate and my Unix server's date is different...would you like to throw some light on this because when I issue select sysdate from dual..it does not show my unix server's date...
Any clue on this??
I believe you are looking at the wrong server. The DB server is indeed where Oracle gets the sysdate from. I just changed it on my DB server (happens to be Windows Server 2012) and on another server where my interface is... I brought up SQLPlus and sure enough... I got the new date. I cannot imagine this is any different on a Unix server. Cheers and best of luck!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|