This makes my head hurt. Please stop.
Printable View
This makes my head hurt. Please stop.
Hey...sorry guys...there was something great I was missing....sorry friends...I got the problem...sorry pando and thanks Slimdave...
Sandy
guess
select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;
!date
worked
:D
Mr. Pando...would you like to take this problem as a challenge...My unix server date and my Oracle date is different. I tried to change my Unix date using 'date' command and after that I issued select sysdate from dual...still it was showing old value...it's a challenge for you...
:D
Quote:
Originally posted by sandycrab
Hey...sorry guys...there was something great I was missing....sorry friends...I got the problem...sorry pando and thanks Slimdave...
Sandy
Do you have it solved or not????Quote:
Mr. Pando...would you like to take this problem as a challenge...My unix server date and my Oracle date is different. I tried to change my Unix date using 'date' command and after that I issued select sysdate from dual...still it was showing old value...it's a challenge for you...
Why don't you post the results of the select statement and the !date output?
Q : select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;
Output : 2003-02-03 09:25:45
Command: !date
Output : Wed Feb 5 16:40:22 CST 2003
It's not a challenge because what you say is not LOGICAL at all, it's how Oracle works, if you see different date then you have problem with your platform and not Oracle's fault.
Or you are comparing local date with remote server date
do
sqlplus
select host_name from v$instance;
!uname -a
select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;
!date
and post results here
I did extensive Y2K testing on a system for Procter & Gamble in Cincinatti (USA) and Dartford (UK) and I can assure anyone out there that Pando is correct, Oracle definitely gets it's date from the OS.
Pando - Close your eyes and take several long deep breaths. It's gonna be OK :)
Cheers
Hi
ohh..my gawd..just how patient pando..is...:p
regards
Hrishy
My suspicion:
He/she is performing all this on the workstation, not on the server where database is running. So select from dual shows a date of the host runing the database, while !date shows the date of the client machine.