Home » SQL & PL/SQL » SQL & PL/SQL » Sysdate is not working (Win XP ,Oracle 9i)
icon12.gif  Sysdate is not working [message #330235] Sat, 28 June 2008 02:13 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Today when i run this (select sysdate,current_timestamp from dual;) script

Output is
------------
sysdate current_timestamp
6/25/2008 10:04:00 AM 28-JUN-08 11.57.12.843000 AM +05:30

Then to correct my sysdate used following script

ALTER SYSTEM SET FIXED_DATE= '2008-06-28-11:57:12';

select sysdate,current_timestamp from dual;
Output is
------------
sysdate current_timestamp
6/28/2008 11:57:12 AM 28-JUN-08 12.22.58.515000 PM +05:30

Sysdate is not updating;
How can I solve this
Please help me .Thanks in Advance
Re: Sysdate is not working [message #330241 is a reply to message #330235] Sat, 28 June 2008 02:58 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Change the date/time settings on the Server that contains the database.
Re: Sysdate is not working [message #330247 is a reply to message #330241] Sat, 28 June 2008 03:26 Go to previous messageGo to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

The date time settings are already correct Sir .Eventhough the above mentioned problem is there
Re: Sysdate is not working [message #330249 is a reply to message #330247] Sat, 28 June 2008 03:54 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Set the fixed_date to none and don't change parameters unless you know what they do and how they behave (i.e. look them up in the documentation before you change them).
SYSDATE returns the date as it is on the operating system upon which the database resides as per the documentation:
docs
The only thing I can guess is that you are connecting to a db on a server other than the one that you think that you are.
Re: Sysdate is not working [message #330411 is a reply to message #330249] Mon, 30 June 2008 02:15 Go to previous message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Yes Sir I am connecting to a db on server .Where server date is correct
Previous Topic: Parameterized view
Next Topic: I am unable to create a nested table (merged)
Goto Forum:
  


Current Time: Sat Dec 03 14:05:58 CST 2016

Total time taken to generate the page: 0.04718 seconds