Home » RDBMS Server » Server Administration » Oracle Server date
Oracle Server date [message #295064] Mon, 21 January 2008 04:27 Go to next message
deepak samal
Messages: 29
Registered: February 2005
Junior Member
HI,

How can i check the oracle server date. Is it possible that i can change the oracle server date.

I think SysDate gives the system date.
select sysdate from dual; -- Gives the system date

so how can i get the oracle server date.

Please help me out.

thanks in advance
Deepak
Re: Oracle Server date [message #295070 is a reply to message #295064] Mon, 21 January 2008 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From documentation: "SYSDATE returns the current date and time set for the operating system on which the database resides."
So this is server date.

Regards
Michel
Re: Oracle Server date [message #295071 is a reply to message #295064] Mon, 21 January 2008 04:39 Go to previous message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member


Oracle takes date/time values from OS. Manipulate OS date /time if you desire.

Regards

Manjit Kumar [mkbhati]

Previous Topic: Flushing Shared Pool
Next Topic: disable parallelins at database level
Goto Forum:
  


Current Time: Tue Dec 06 08:35:39 CST 2016

Total time taken to generate the page: 0.11338 seconds